From: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
---|---|
To: | Dale Anderson <danderso(at)crystalsugar(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Date & Time |
Date: | 1999-11-30 22:48:13 |
Message-ID: | 19991130164813.A9625@wallace.ece.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dale -
How about this?
Ross
test=> create table test (t_id int, start datetime, what text);
CREATE
test=> insert into test values (123, now(), 'Name');
INSERT 684299 1
test=> select * from test;
t_id|start |what
----+----------------------------+----
123|Tue Nov 30 16:46:07 1999 CST|Name
(1 row)
test=> insert into test values (456, now(), 'Other');
INSERT 684300 1
test=> select * from test;
t_id|start |what
----+----------------------------+----
123|Tue Nov 30 16:46:07 1999 CST|Name
456|Tue Nov 30 16:46:15 1999 CST|Other
(2 rows)
test=>
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
On Tue, Nov 30, 1999 at 04:34:34PM -0600, Dale Anderson wrote:
> How would I insert the current date & time into a record during an insert, IE such as the Oracle SYSDATE function??
>
> ( insert into test values (123, SYSDATE, 'Name');
>
> Thanks,
> Dale.
>
>
>
> ************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-11-30 23:58:25 | Re: [GENERAL] Date & Time |
Previous Message | Dale Anderson | 1999-11-30 22:34:34 | Date & Time |