Re: [GENERAL] Date & Time

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.
>
>
>
> ************
>