Sorry, how do i format the date and time so its like this
092820121046
to mmddyyyhhhh?
On Friday, September 28, 2012 10:41:48 AM UTC-7, sc8132 wrote:
>
> you're awesome.. thank you!!!
>
>
>
> On Thursday, September 27, 2012 5:46:14 PM UTC-7, Brian wrote:
>>
>> 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/-/hbd2ZlUe2PIJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
