year , month, day from this filed

[Anonymous]

Hi i need to get year, month, day as seperate fields from the following format:

2011-09-19T15:44:34.038Z

2015-07-22T10:02:23.856Z

2015-02-11T21:27:58.174Z

2015-07-09T12:08:36.977Z

2015-07-28T11:04:55.113Z

2015-07-28T16:58:34.523Z

[sunny_talwar]

May be like this:

Table:

LOAD Year(TimeStamp) as Year,

  TimeStamp,

  Month(TimeStamp) as Month,

  Day(TimeStamp) as Day,

  Date(Floor(TimeStamp)) as Date;

LOAD TimeStamp(Date#(Replace(Replace(TimeStamp, 'T', ' '), 'Z', ''), 'YYYY-MM-DD h:mm:ss.fff')) as TimeStamp;

LOAD * INLINE [

    TimeStamp

    2011-09-19T15:44:34.038Z

    2015-07-22T10:02:23.856Z

    2015-02-11T21:27:58.174Z

    2015-07-09T12:08:36.977Z

    2015-07-28T11:04:55.113Z

    2015-07-28T16:58:34.523Z

];

[vishsaggi]

May be like this?

Date#(Subfield(DateValue, 'T',1), 'MM-DD-YYYY')