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 ?