[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 |   Modifiers
---+- 
+
 testfield | timestamp without time zone | not null default '1979-11-03  
22:05:58'



Tim Uckun heeft op woensdag, 5 feb 2003 om 00:32 (Europe/Amsterdam) het  
volgende geschreven:





I don't know if anybody has already done this or not but be sure to  
change the postgresql schema file. Currently you are specifying a  
DATETIME field when it should be TIMESTAMP. DATETIME is not a valid  
postgresql field type.



:wq
Tim Uckun
US Investigations Services/Due Diligence
 http://www.diligence.com/

___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


Met vriendelijke groet,


Roel Rozendaal


_
R.A. Rozendaal
ICT Manager
ICS
T: +31 30 2322878
F: +31 30 2322305
www.ic-s.nl

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/