Specifying current date and substring in virtual table
Posted: Wed Aug 07, 2013 12:08 pm
Hi
i'm trying to create conditions for virtual table in column analysis,
having difficulty in specifying "current date" and extracting date from timestamp column and comparing, like below, can someone help me?
col1 <= sysdate /* how to specify sysdate in the condition box
date(col2) < '2013-12-31' /*how to extract date from timestamp and comparing against a specified date, the data type of col2 is timestamp
cheers
mj
i'm trying to create conditions for virtual table in column analysis,
having difficulty in specifying "current date" and extracting date from timestamp column and comparing, like below, can someone help me?
col1 <= sysdate /* how to specify sysdate in the condition box
date(col2) < '2013-12-31' /*how to extract date from timestamp and comparing against a specified date, the data type of col2 is timestamp
cheers
mj