topic Re: time in QlikView

time

Tue, 17 Jun 2014 12:14:46 GMT

hello,

I have my field in this form '10 / 20/2013 11:34:00 p.m. 'and I just would like to retrieve the time. how?

Re: time

Gysbert_Wassenaar — Tue, 17 Jun 2014 12:20:03 GMT

=time#(PurgeChar(right('10 / 20/2013 11:34:00 p.m.',13),'.'),'hh:mm:ss tt')

Re: time

tresB — Tue, 17 Jun 2014 12:20:42 GMT

Use Frac(), like:

Load

Time(Frac(YourField)) as Time

Re: time

er_mohit — Tue, 17 Jun 2014 12:22:33 GMT

Try this in text object

=time(time#('10/20/2013 11:34:00 p.m.','MM/DD/YYYY hh:mm:ss tf'),'hh:mm:ss tt')

Re: time

Tue, 17 Jun 2014 12:31:10 GMT

II tried but it shows me nothing

Re: time

Anonymous — Tue, 17 Jun 2014 12:32:33 GMT

use the Mid function

Mid(Fieldname, time starting string no, time end string no)

Another type is

Use the Timestamp function

timestamp(fieldname, 'Time format')

Re: time

tresB — Tue, 17 Jun 2014 12:38:00 GMT

That could be because your data is not really of timestamp nature. In that case it has to be parsed properly so that qv can read it as a timestamp. Try like:

Time(Frac(time#(YourField, 'MM/DD/YYY hh:mm:ss tt') )) as time

Ensure that 'MM/DD/YYY hh:mm:ss tt' is exactly same (even spaces would be considered)