If I export a file containing date field,
export to "/james/j.txt" of DEL
select a1,adate from a
The date is represented in YYYY/MM/DD format as expected.
Output I need is to be in "yyyymmdd" without delimiter. MODIFIED BY
DATESISO option has a delimiter.
I am getting the same ouput despite using the following:
export to "/james/j.txt" of DEL
select a1,replace(char(adate),'/','') from a
From using just the select statement and running from command line with
-z option, I am able to redirect output to a file, but it is not in CSV
format. This is a big SQL and I do not want to manually insert commas
to separate in select statement.
Can someone throw light on this. Specifically for the export with
modified by, and for using select in command line and get a CSV format.
Thanks a bunch.