Re: Current time into Timestamp
From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 03 Jun 2003 17:59:44 -0700
Message-ID: <4wbDa.62606$MJ5.33457_at_fed1read03>
Date: Tue, 03 Jun 2003 17:59:44 -0700
Message-ID: <4wbDa.62606$MJ5.33457_at_fed1read03>
John Luongs wrote:
> How do I put the current time into the timestamp data type. Thanks.
>
> insert into USERS ( USER_ID, CREATED)
> values
> ('jimoore', ?timestamp?);
>
>
insert into USERS ( USER_ID, CREATED) values ('jimoore', SYSDATE);
- ASSUMING THAT "CREATED" IS OF TYPE DATE