Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

date and time

Hi there,

Need some assistance with Date and Time fields. I have got an extract below from excel (sample also attached):

DATETIME
16/07/20109:43:00 AM
16/07/201010:24:00 AM
17/07/201012:34:00 AM
17/07/20104:49:00 AM


When its loaded in Qlikview it appears as below:

DATETIME
2010-07-1609:43:00.00000000000042375
2010-07-1610:24:00.00000000000127800
2010-07-1700:33:59.999999999999946525
2010-07-1704:48:59.99999999999834700

I want it to appear as:

date: 13/07/2011

time: 15:23:12

Please assist.

Thanks in advance.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this in script

LOAD

Date(DATE, 'DD/MM/YYYY') AS DATE,

TIME(TIME, 'hh:mm:ss TT') AS TIME

FROM DataSource;

REgards,

Jagan.

View solution in original post

3 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this in script

LOAD

Date(DATE, 'DD/MM/YYYY') AS DATE,

TIME(TIME, 'hh:mm:ss TT') AS TIME

FROM DataSource;

REgards,

Jagan.

Anonymous
Not applicable
Author

Thanks a lot Jagan.

Really appreciated it.

Cheers!!!

Not applicable
Author

HI Jagan Can u please look on my discussion and please suggest me some answer ,