From: Raymond Chui <raymond.chui@noaa.gov>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
To: pgsql-admin@postgresql.org
Subject: CURRENT_TIMSTAMP
Date: Mon, 02 Dec 2002 11:41:33 -0500
Message-ID: <3DEB8D3D.5353D375@noaa.gov> (raw)
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!
Attachments:raymond.chui.vcf (text/x-vcard, 311B) download
begin:vcard
n:Chui;Raymond
tel;work:301-713-0640 x168
x-mozilla-html:FALSE
url:http://www.nws.noaa.gov/
org:NWS, NOAA;OHD13
version:2.1
email;internet:raymond.chui@noaa.gov
title:CS
adr;quoted-printable:;;1325 East-West Highway=0D=0ASSMC2, Room 8112;Silver Spring;MD;20910-3282;U.S.A.
fn:Raymond Chui
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: raymond.chui@noaa.gov, pgsql-general@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: CURRENT_TIMSTAMP
In-Reply-To: <3DEB8D3D.5353D375@noaa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox