timestamp

[sara1231]

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_TIMESTA MP

i have only read access to this remote db.

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

thanks
sara

[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_TIMESTA MP

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