[Dbmail] DATETIME vs TIMESTAMP

2003-02-05 Thread Roel Rozendaal - ICS
works on my postgresql.. I'm using 7.2.1; i tried the following in the psql program: dbmail=# create table testtable (testfield DATETIME DEFAULT '1979-11-03 22:05:58' NOT NULL); CREATE dbmail=# \d testtable Table testtable Column |Type

Re: [Dbmail] DATETIME vs TIMESTAMP

2003-02-05 Thread Tim Uckun
At 09:29 AM 2/5/2003 +0100, you wrote: works on my postgresql.. I'm using 7.2.1; i tried the following in the psql program: It did not work on 7.3.1. Perhaps they changed it. :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/