Date conversion

[brindlogcool]

I have a date field which is always showing as Text format even after using interpretation function Date#. The data source is Txt file.

I tried Date#()

I tried floor with Date#()

Still no use. But i had another txt file which has date function and it is working perfectly fine using the interpretation function Date#.

Not able to identify root cause for the issue. And more concern is when the function is working with one text file and not working with other,

i had through HIC posts related to date filed but nothing works. Is it anything related to encoding format.

[pokassov]

Sure

t1:

LOAD @1 as textdata

FROM

(txt, codepage is 1251, no labels, delimiter is '\t', msq);

t2:

LOAD

  date(date#(data,'MM/DD/YYYY hh:mm:ss')) as data,

  Timestamp(Timestamp#(data,'MM/DD/YYYY hh:mm:ss')) as datatime;

LOAD

mid(textdata,23,19) as data

Resident

  t1;

Result's the same. OK

Did your try Inline?