Yes, here's an example:
insert into "Transaction" (
"nImportId",
"dPosted",
"nAccountId",
"tAccountTransactionId",
"nAmount",
"tDescription",
"tLocation")
select
1 "nImportId",
convert(parsedatetime("Posted Date",'MM/dd/yyyy'), timestamp)
"dPosted",
3 "nAccountId",
"Reference Number" "tAccountTransactionId",
convert("AMOUNT", decimal (10,2)) "nAmount",
"PAYEE" "tDescription",
"ADDRESS" "tLocation"
from
CSVREAD('2011-03-10.csv');
On Apr 6, 10:12 am, 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?
>
> Thanks,
> Zac
--
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.
