Converting general field from excel to datetime

[#1]

hi everyone,

I want to know how to convert general field from excel to datetime. I have tried with date and date# functions but it is not giving me proper output.

excel file is attached herewith.

Please help with this

[swuehl]

timestamp#() or date#() with an appropriate format code string should work. Worked for me:

LOAD timestamp#(Time,'YYYY.MM.DD hh:mm:ss.ffff') as Time,

     INV_1.AC_Pow.C2.AVG_WT0,

     INV_1.DC_Pow.C2.AVG_WT0,

     INV_1.Total_Energy.C2.MAX,

     INV_1.INV_No

FROM

SI01.xls

(biff, embedded labels, table is [Inverter1$]);

[#3]

hey..

I tried with this solution.But still when I am extracting year from time as 'year(Time)' ,it is not giving me output.

[swuehl]

If you succesfully interpreted your Time field as timestamp, year(Time) does work.

Check attached.