Cuurentimestamp Function in DB2 stag2
Posted: Tue Feb 28, 2006 8:58 am
Hi,
I have to use a query in DB2 stage SELECT * FROM TABLE_NAME WHERE DATE <= "Current timestamp"
Can any one tells me about the MetaSQL function which can be used for CurrentTimestamp.
%CurrentDateTimeIn() == is the right function or not?
Kindly help me
I have to use a query in DB2 stage SELECT * FROM TABLE_NAME WHERE DATE <= "Current timestamp"
Can any one tells me about the MetaSQL function which can be used for CurrentTimestamp.
%CurrentDateTimeIn() == is the right function or not?
Kindly help me