Bringing uniform timestamp

    Hi All,

    How to bring to uniform time stamp if we have different timestamps from the same field?

    Here is the solution.

     

    Data:
    LOAD *,TimeStamp(
       Alt(
          TimeStamp#(Date_Value,'YYYY-MM-DD hh:mm'),
          TimeStamp#(Date_Value,'M/D/YY h:mm')
          ),
          'YYYY-MM-DD hh:mm'
       ) as New_Date_Value;
    Load * inline [
    Date_Value
    2001-12-06 23:00
    2001-12-06 23:12
    2001-12-06 23:22
    2001-12-06 23:38
    2001-12-06 23:39
    1/13/06 0:00
    1/13/06 0:00
    1/13/06 0:01
    1/13/06 0:01
    1/13/06 0:01
    1/13/06 0:01
    1/13/06 0:09
    1/13/06 0:28
    1/13/06 1:12
    1/13/06 1:12
    1/13/06 1:30
    ];
    
    
    

     

    Capture.JPG