Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Need some assistance with Date and Time fields. I have got an extract below from excel (sample also attached):
DATE | TIME |
16/07/2010 | 9:43:00 AM |
16/07/2010 | 10:24:00 AM |
17/07/2010 | 12:34:00 AM |
17/07/2010 | 4:49:00 AM |
When its loaded in Qlikview it appears as below:
DATE | TIME |
2010-07-16 | 09:43:00.00000000000042375 |
2010-07-16 | 10:24:00.00000000000127800 |
2010-07-17 | 00:33:59.999999999999946525 |
2010-07-17 | 04:48:59.99999999999834700 |
I want it to appear as:
date: 13/07/2011
time: 15:23:12
Please assist.
Thanks in advance.
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.
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.
Thanks a lot Jagan.
Really appreciated it.
Cheers!!!
HI Jagan Can u please look on my discussion and please suggest me some answer ,