Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more 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:
‎09-03-2015 09:46 PM
Updated by: