Date Type Question

swaxolez · Post by **swaxolez** » Thu 28 Feb 2008 00:45

I'm sure this is a really obvious fix but it alludes me so far. My database has several date fields that when I go to update through pgsqldatasource gets treated as a timestamp and then throws an error. If before I go to update I remove the time portion (in this case always 12:00:00 am) then everything works fine. How do I make visual studio treat my postgresql date field as only a date field ('2007-01-01') and not a timestamp ('2007-01-01 12:00:00 am).

Cheers

swaxolez · Post by **swaxolez** » Thu 28 Feb 2008 01:09

Okay I figured it out - had to change parameter type to Datetime. However, you would think that when the connector is created it would also correctly set each data type - as it is everything is set to type string.

Alexey.mdr · Post by **Alexey.mdr** » Thu 28 Feb 2008 11:47

Could you please specify the question?
Do you have any errors?
What data type do you feel uncertain about?