Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: web service + postgres stored procedure error

    I have an web service with some functions that calls some postgresql
    stored procedures ...
    when I click the invoke button the following error mesage appears :

    Cannot convert 18/05/2006 to System.DateTime.
    Parameter name: type --> String was not recognized as a valid DateTime.

    I don't know why it appears because in both web service and postgresql stored procedure the field is declared as data

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    PostgreSQL's date formatting is probably not set to match your regional settings.

    Either change the regional date settings in the PG server, or format your date so that it is unequivocal. DD-MMM-YYYY, for instance.

    Ref Chapter 21 in the pg documention.
    Last edited by loquin; 05-18-06 at 13:16.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •