From: | hoelc <hoelc(at)pd(dot)jaring(dot)my> |
---|---|
To: | pgsql-admin(at)hub(dot)org, pgsql-admin(at)postgreSQL(dot)org, pgsql-general(at)hub(dot)org |
Subject: | date & time |
Date: | 1999-03-06 17:20:23 |
Message-ID: | 36E163D7.CD95C55A@pd.jaring.my |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
Hello,
Can some one please tell me how to set the date&time in the PostgreSQL
system?
I try to use date('now') and time('now') to keep tract of the data and
time when the data is inserted or updated. When I use sql " insert into
table (data1, date_chg, time_chg) values ('abc',date('now'),time('now'))
" to insert the date and time data, the data successfully inserted but
when I retrive the data, it shows that the date and time is always "
01-01-2000 " and " 08:00:00 " , now is of couse not year 2000 and the
time is also not 8 o'clock. Why? How should I correct this?
I am using PostgreSQL in Linux system, and the date & time for Linux
system are correct.
One more question, what is the common data type for storing address?
Thank you very much.
Regards .... lch
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Heflin | 1999-03-06 17:25:48 | Re: [GENERAL] date & time |
Previous Message | Simon Drabble | 1999-03-06 14:15:30 | Re: [GENERAL] Compile |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Heflin | 1999-03-06 17:25:48 | Re: [GENERAL] date & time |
Previous Message | Michael Meskes | 1999-03-06 12:54:32 | Re: [INTERFACES] Counting updates with libpq |