Query on unloading date field using DSNTIAUL

IBM's flagship relational database management system

Query on unloading date field using DSNTIAUL

Postby novice2erudite » Wed Dec 17, 2014 10:17 am

I have a date field in a table which I am unloading using DSNTIAUL.
The format in which the date is getting displayed is 'YYYY-MM-DD.'
I would like to get the date without '.' in the end (as YYYY-MM-DD).
I tried using below query
select char(date) from table;
but still the '.' persists. I even tried the below query
select substr(char(date),1,10) from table;
The above query resulted in 'YYYY-MM-DD.' which I found to be little weird.
Can someone help on this ?
Posts: 6
Joined: Wed Nov 06, 2013 11:55 am
Has thanked: 0 time
Been thanked: 0 time

Return to DB2


  • Related topics
    Last post