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