Hi, This question was already asked here: http://stackoverflow.com/questions/19337652/h2-parsedatetime-of-csv-file - if somebody wants to answer please use StackOverflow.
Regards, Thomas On Mon, Oct 14, 2013 at 7:49 PM, Pablo Lozano <[email protected]> wrote: > I have a csv file that need to import using CSVREAD. The issue is that it > has date time format in a different way so a need to parse it. Can some one > give me an example of how i am supposed to do it? > > I tried: merge into MESSAGE > (MESG_DATE_FROM,MESG_DATE_TO,MESG_DISPLAY_SEQ,MESG_TIME_DELAY,MESG_ID,REASONTYPE_MAJOR) > SELECT MESG_DATE_FROM , MESG_DATE_TO, > MESG_DISPLAY_SEQ,MESG_TIME_DELAY,MESG_ID,REASONTYPE_MAJOR) FROM > CSVREAD('cache\MESSAGE_0.dat'); > > This querys are made programatically so they cannot be handmade. The > problem is that some columns are datetime type and are in a different > datetime format from the one in H2, at the moment of parsing i have no > precise way of determining which columns will be datetime so i cannot > easily put a PARSEDATETIME and the CSV file doesnt contains any column > names or info, just the values. Like this: 2011-11-18 > 00.00.00.00,2030-12-31 00.00.00.00,1,20000,1,0, ... > ... > > An Sql file will be generated to load this CSV to each table but it seems > i need to know if a column is of TIMESTAMP type to add > PARSEDATETIME(MESG_DATE_FROM,'yyyy-mm-dd hh.mm.ss.uu') as MESG_DATE_FROM to > the sql. Tables and Columns are autogenerated by code and i can't control > if a column will be of certain type or a new column is added. As of right > now the only way i can imagine of adding the > PARSEDATETIME(MESG_DATE_FROM,'yyyy-mm-dd hh.mm.ss.uu') as MESG_DATE_FROM is > to ask each column for its type at runtime. > > In DB2 we could use a timestampformat=YYYY-MM-DD HH.MM.SS.UU in the merge > query so this was done in a default way for tables. Is there anythis > similar in H2? > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
