Hello,
Recently, I tried to export some tables with the function CSVWRITE().
I use it as following
CALL CSVWRITE('file_name', 'SELECT * WHERE datetime_column=yyyy-mm-dd
hh:mm:ss')
However, this syntax is always considered as incorrect.
In the CSVWRITE function, the whole query is between single quotes '
'. So, I tried to put the datetime between single quotes 'yyyy-mm-dd
hh:mm:ss', double quotes "yyyy-mm-dd hh:mm:ss", and both escaped
(\'yyyy-mm-dd hh:mm:ss\' and \"yyyy-mm-dd hh:mm:ss\").
But nothing worked.
Did I make something wrong or is it impossible to select by dates ?
Maybe I missed something I'm not a DB professionnal :)
Thank you for your answer.
Guillaume
By the way, the performances of this DB are awesome !
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
