Qlik Community

QlikView Documents

Documents for QlikView related information.

Bringing uniform timestamp

Arjunarao
Honored Contributor II

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

Attachments
Comments
kuczynska
Contributor III

Good stuff! not happening that often in my experience, but it's worth knowing this small trick of yours!

Version history
Revision #:
1 of 1
Last update:
‎2015-09-03 09:46 PM
Updated by: