467,179 Members | 1,197 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,179 developers. It's quick & easy.

Syntax to Update Timestamp Column

Hi,

I have a column with Timestamp data type. Now i need to update the column.
How do i Update the column.

Could anyone send me the syntax??

Thanx in advance !
Aug 29 '07 #1
  • viewed: 8003
Share:
1 Reply
Hi,

I have a column with Timestamp data type. Now i need to update the column.
How do i Update the column.

Could anyone send me the syntax??

Thanx in advance !
Shouldn't be any different from any other column type. Update table_name set timestamp_column = current timestamp. if you use a host variable instead of current timestamp, you need to make sure that the host variable contains a properly formatted timestamp value.
Aug 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Harald Servat Gelabert | last post: by
7 posts views Thread by Dave | last post: by
3 posts views Thread by tsarevich@gmail.com | last post: by
6 posts views Thread by Scott Nixon | last post: by
5 posts views Thread by wpellett@prodigy.net | last post: by
2 posts views Thread by mokazawa1@gmail.com | last post: by
13 posts views Thread by dennis@geysirheste.dk | last post: by
3 posts views Thread by Michel Esber | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.