"now" performs better in this case:
insert into test values (123, 'now','Name');
now() is needed for "default" in create table, because
"now" won't work right (a bug/feature ?).
see archive in this list
On Tue, 30 Nov 1999, Ross J. Reedstrom wrote:
> 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.
> >
> >
> >
> > ************
> >
>
> ************
>
