CURRENT_TIMSTAMP - Mailing list pgsql-sql

From Raymond Chui
Subject CURRENT_TIMSTAMP
Date
Msg-id 3DEB8D3D.5353D375@noaa.gov
Whole thread Raw
Responses Re: CURRENT_TIMSTAMP  (Joel Burton <joel@joelburton.com>)
Re: CURRENT_TIMSTAMP  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
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

yyyy-mm-dd HH:MM:ss.mmmmm+00

where mmmmm is milliseconds.
How do I make default only yyyy-mm-dd HH:MM:ss+00 ?
Thank Q!


Attachment

pgsql-sql by date:

Previous
From: Evgen Potemkin
Date:
Subject: SQL99
Next
From: smoshiro@hotmail.com (Sergio Oshiro)
Date:
Subject: Min and Max