By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

timestamp

P: 2
Hi,

I'm new to DB2.

I'm connecting to a remote database through command line processor, while trying to retrieve records based on timestamp , i'm getting an error.

select * from user.file where log_time <= CURRENT_TIMESTAMP

i have only read access to this remote db.

What is the correct syntax to use current timestamp from CLP?

thanks
sara
Jun 25 '07 #1
Share this Question
Share on Google+
1 Reply


rickbray66
P: 7
Hi,

I'm new to DB2.

I'm connecting to a remote database through command line processor, while trying to retrieve records based on timestamp , i'm getting an error.

select * from user.file where log_time <= CURRENT_TIMESTAMP

i have only read access to this remote db.

What is the correct syntax to use current timestamp from CLP?

thanks
sara

Hi Sara.

I'm also new to DB2. You may want to try using "CURRENT TIMESTAMP" (no underscore between current and timestamp). That has worked for me in "CREATE/ALTER TABLE" statements.


Rick
Jun 25 '07 #2

Post your reply

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