Hi,
I have to port an application from MS SQL7 to Postgresql (7.4).
When I have a column with a datetime on MS SQL7 the following is possible:
INSERT INTO mytable (mydate) values ('');
In this case MSSQL will insert '01.01.1900' as the date.
When I do the same on Postgresql it says:
"invalid input syntax for type timestamp with time zone: ''".
Unfortunately the application I have to port often uses '' as a date.
My question:
Is there any way to have MSSQLs behavior in PostgreSQL?
Thanks for answers
--
Telefonieren Sie schon oder sparen Sie noch?
NEU: GMX Phone_Flat http://www.gmx.net/de/go/telefonie
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
