From: tolik@icomm.ru
To: hoelc@pd.jaring.my
Cc: pgsql-admin@hub.org
Cc: pgsql-admin@postgreSQL.org
Cc: pgsql-general@hub.org
Subject: Re: [ADMIN] date & time
Date: 07 Mar 1999 12:56:05 +0300
Message-ID: <87emn1fwsq.fsf@tolikus.hq.aaanet.ru> (raw)
References: <36E163D7.CD95C55A@pd.jaring.my>
>>>>> "h" == hoelc <hoelc@pd.jaring.my> writes:
h> Hello,
h> Can some one please tell me how to set the date&time in the PostgreSQL
h> system?
h> I try to use date('now') and time('now') to keep tract of the data and
h> time when the data is inserted or updated. When I use sql " insert into
h> table (data1, date_chg, time_chg) values ('abc',date('now'),time('now'))
h> " to insert the date and time data, the data successfully inserted but
h> when I retrive the data, it shows that the date and time is always "
h> 01-01-2000 " and " 08:00:00 " , now is of couse not year 2000 and the
h> time is also not 8 o'clock. Why? How should I correct this?
h> I am using PostgreSQL in Linux system, and the date & time for Linux
h> system are correct.
Yes, here is the problem:
tolik=> select date('now'), time('now');
date|time
----------+--------
01-01-2000|03:00:00
(1 row)
Here is the solution:
tolik=> select date('now'::datetime), time('now'::datetime);
date|time
----------+--------
03-07-1999|13:00:55
(1 row)
--
Anatoly K. Lasareff Email: tolik@icomm.ru
Senior programmer
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-interfaces@postgresql.org
Cc: tolik@icomm.ru, hoelc@pd.jaring.my, pgsql-admin@hub.org, pgsql-admin@postgreSQL.org, pgsql-general@hub.org
Subject: Re: [ADMIN] date & time
In-Reply-To: <87emn1fwsq.fsf@tolikus.hq.aaanet.ru>
* 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