| Subject | Using timestamp in dialect 1 | 
|---|---|
| Author | Nick Upson | 
| Post date | 2005-02-17T17:46:04Z | 
Can anyone see a problem with changing 
new.DT_ENTERED = 'NOW';
into
new.DT_ENTERED = CAST('NOW' AS TIMESTAMP);
within a 1.5.2 database dialect 1 so that it is ready to work correctly in
dialect 3
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
            new.DT_ENTERED = 'NOW';
into
new.DT_ENTERED = CAST('NOW' AS TIMESTAMP);
within a 1.5.2 database dialect 1 so that it is ready to work correctly in
dialect 3
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly