Re: CSVWRITE - Title of CSV File to include system date?

[Brian]

call csvwrite('c:/temp/fileprefix-' || current_date(),'select * from data_push');

On Thursday, September 27, 2012 6:30:03 AM UTC-7, sc8132 wrote:

Hi,

I have a call csvwrite script for my database. How can I include the system date in the title of the csv file?

Here is the current working script:

CALL CSVWRITE('C:\TEMP\exportdata.csv','SELECT "DATA_PUSH".* FROM "PUBLIC"."DATA_PUSH" "DATA_PUSH"','fieldDelimiter= writeColumnHeader=false');

Thanks!

Sherry

[sc8132]

you're awesome.. thank you!!!

[sc8132]

Sorry, how do i format the date and time so its like this

092820121046

to mmddyyyhhhh?

[Brian]

CALL FORMATDATETIME(CURRENT_TIMESTAMP(), 'MdyyyyHHmm', 'en', 'GMT')
Per:
http://www.h2database.com/html/functions.html?highlight=CURRENT_DATE&search=current_#formatdatetime
http://docs.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html

If you're keeping the files however, sometimes it's best to use yyyyMdHHmm so they appear chronologically in directory/file listings etc...