Date Type

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Guest

Date Type

Post by 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?

SecureGen
Devart Team
Posts: 133
Joined: Thu 08 Sep 2005 06:27

Post by 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?

Post Reply