topic Re: Date time conversion in QlikView

Date time conversion

brindlogcool — Sat, 03 Mar 2012 02:17:35 GMT

Hi ,

How to convert the 12hr format to 24hr format.

Date time conversion

phaneendra_kunc — Sat, 03 Mar 2012 05:34:42 GMT

Hi,

First make sure your time format is set to below formats.

1.) 24hr to 12hr:

SET TimeFormat='hh:mm:ss[.fff]';

syntax: Timestamp('YourTimeField' ,'hh:mm:ss TT')

2.) 12hr to 24hr:

SET TimeFormat='hh:mm:ss TT';

syntax: Timestamp('YourTimeField' ,'hh:mm:ss')

Regards,

Phani

Date time conversion

brindlogcool — Sat, 03 Mar 2012 15:43:05 GMT

Thanks for your response. My Currenttimestamp is 'hh:mm:ss TT'. I have two datetime Field one it is showing in 24 hr format. Other it is showing in the 12 hr format which is coming as the output of ConvertToLocalTime.

Re: Date time conversion

phaneendra_kunc — Sat, 03 Mar 2012 17:04:07 GMT

Didin't understand why you were not able to convert to 24hr.

See attached if that help's....

if not throw a sample where you are not able to convert.

Regards,

Phani

Date time conversion

jonathandienst — Sun, 04 Mar 2012 06:57:52 GMT

Try something like (change to the correct field name):

Time(Time#(ConvertToLocalTime(TimeValueField), 'hh:mm:ss TT'),'hh:mm:ss');

Regards

Jonathan

Date time conversion

brindlogcool — Sun, 04 Mar 2012 07:49:34 GMT

Thanks for all your response.