Simple inline load question

Tue, 30 Jul 2013 14:39:38 GMT

Hi All,

I am trying to load an inline table with datetime.

My data in in 'DD/MM/YYYY hh:mm:ss' format.

Here is the script I originally used

[DTAB]:

load * inline

[DT1,DT2

1/2/2013 11:45:12, 3/16/2013 12:12:12

7/10/2013 10:40:05,7/16/2013 05:10:01];

but this resulted in a text load.

So I tried with the explicit date format and the it came out as null

load * ,

date(date#(DT1,'DD.MM.YYYY hh:mm:ss'),'DD.MM.YYYY hh:mm:ss') as I_DT1,

date(date#(DT1,'DD.MM.YYYY hh:mm:ss'),'DD.MM.YYYY hh:mm:ss') as I_DT2,

date(DT1,'DD.MM.YYYY hh:mm:ss') as II_DT1,

date(DT1,'DD.MM.YYYY hh:mm:ss') as II_DT2

inline

[DT1,DT2

1/2/2013 11:45:12, 3/16/2013 12:12:12

7/10/2013 10:40:05,7/16/2013 05:10:01];

Anyone would please be able to provide some details on this?

Thanks,

Re: Simple inline load question

jonathandienst — Tue, 30 Jul 2013 14:57:18 GMT

you need

date(date#(DT1,'D/M/YYYY hh:mm:ss'), ...)

Jonathan

Tue, 30 Jul 2013 15:00:13 GMT

Thanks Jonathan!

I have been chaning the format for a while and never noticed that ....