Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 what is the equivalent of sql getdate() in AS/400

Author  Topic 

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2010-02-07 : 07:32:37
I have a datetime column in AS/400 file, I want to update that column which is in AS/400 with the current date. I will be using sql query for doing that update, tried getdate() but getting error. Let me know what is the equivalent of getdate() that I can use to update the column in AS/400 file. Thanks.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-02-07 : 09:49:39
CURRENT_TIMESTAMP
Go to Top of Page
   

- Advertisement -