Page 1 of 1

Date Type

Posted: Fri 17 Feb 2006 21:14
by Guest
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?

Posted: Tue 21 Feb 2006 10:03
by SecureGen
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?