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.