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
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/uFEVUkCINhYJ.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to