Troy Hall
asked on
Insert current timestamp into time stamp column with sql statement
How can I insert the current timestamp in to a timestamp column with the insert sql statement?
I have tried:
insert into schema.table
values(current_timestamp);
As well as "current time" , current_time, current_date, current date. No luck.
Thanks. Troy
ASKER
a column defined as type "Z", is a timestamp column. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Which column do you want to insert the current timestamp into?