date and time

[Anonymous]

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.

[jagan · Accepted solution]

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]

Thanks a lot Jagan.

Really appreciated it.

Cheers!!!

[#4]

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