467,923 Members | 1,845 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

timestamp

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
  • viewed: 1745
Share:
1 Reply
rickbray66
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.

Similar topics

2 posts views Thread by rong.guo | last post: by
5 posts views Thread by Prabu Subroto | last post: by
7 posts views Thread by JJ | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.