Re: [SQL] CURRENT_TIMSTAMP

2002-12-02 Thread Stephan Szabo
On Mon, 2 Dec 2002, Raymond Chui wrote: > I created a column, dada type timstamp with time zone > and with default CURRENT_TIMSTAMP > it shows me the default is > > default ('now'::text)::timstamp(6) with time zone > > Then when I insert a row, the default timestamp value is > > -mm-dd HH:MM:s

Re: [SQL] CURRENT_TIMSTAMP

2002-12-02 Thread Joel Burton
On Mon, Dec 02, 2002 at 11:41:33AM -0500, Raymond Chui wrote: > I created a column, dada type timstamp with time zone > and with default CURRENT_TIMSTAMP > it shows me the default is > > default ('now'::text)::timstamp(6) with time zone > > Then when I insert a row, the default timestamp value is

[SQL] CURRENT_TIMSTAMP

2002-12-02 Thread Raymond Chui
I created a column, dada type timstamp with time zone and with default CURRENT_TIMSTAMP it shows me the default is default ('now'::text)::timstamp(6) with time zone Then when I insert a row, the default timestamp value is -mm-dd HH:MM:ss.m+00 where m is milliseconds. How do I make d