Date Type Question

Date Type Question

Postby 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
 
Posts: 5
Joined: Thu 28 Feb 2008 00:40

Postby 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.
swaxolez
 
Posts: 5
Joined: Thu 28 Feb 2008 00:40

Postby 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?
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for PostgreSQL