On Apr 6, 4:12 pm, Zac C <[email protected]> wrote: > I'm trying to use CSVREAD to import data previously stored in CSV > files into the database. My dates are in MM/dd/yyyy so the H2 > complains about the date format during the import. Is there any way > to specify a different date format to use when importing from CSV?
I don't think so, for a reason analogous to the one given in http://markmail.org/message/dnwrktgzxohuy62c#query:+page:1+mid:qubdmczghtlgr4ia+state:results ("CSVREAD returns VARCHAR for all columns, so converting comma to a dot within CSVREAD would be the wrong place.") A similar workaround should be possible for you. -- 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.
