supernovae
MIS
HI
I have a query on the date format .
I am retrieving data from a SAP DB2 based on selection date.
In the tables , the dates in the table are displayed as yyyymmdd.
When i use the statements
select....
....
where create date = '20020821'(hardcoded)
or
where create date = '2002'||'08'||char(day(current date))
It works ...but when i change the selection to
select...
... where create date = char(year(current date) || char(month(current date)) || char(day(current date)))
the query didnt work ...
Weird..yes..and i cldnt find out y...
Anybody can help me wif this?
Thanks for any replies
I have a query on the date format .
I am retrieving data from a SAP DB2 based on selection date.
In the tables , the dates in the table are displayed as yyyymmdd.
When i use the statements
select....
....
where create date = '20020821'(hardcoded)
or
where create date = '2002'||'08'||char(day(current date))
It works ...but when i change the selection to
select...
... where create date = char(year(current date) || char(month(current date)) || char(day(current date)))
the query didnt work ...
Weird..yes..and i cldnt find out y...
Anybody can help me wif this?
Thanks for any replies