Date Type

Date Type

Postby Guest » Fri 17 Feb 2006 21:14

Again about dates. When I insert into the Database fields with dates I have sometimes exceptions: Not valid date.
For example I have one table with two date fileds. One is Date, another has type dnDate, where dnDate - domain type Date. Try to insert date in format "mm/dd/yyyy" and have problem with type Date. Try to insert date in format "dd/mm/yyyy" and has problem with dnDomain. Why it happens?
Guest
 

Postby SecureGen » Tue 21 Feb 2006 10:03

Did you try to execute INSERT into your test table in the standard Postgre SQL tool like PgAdmin?
Does it work in the same way in your environment?
SecureGen
Devart Team
 
Posts: 133
Joined: Thu 08 Sep 2005 06:27


Return to dotConnect for PostgreSQL