topic Re: Timestamp in QlikView

Timestamp

ankit777 — Fri, 02 May 2014 05:43:56 GMT

Hi All,

In QlikView Script I am generating time in a field using the following function:

timestamp(now(),'DD-MMM-YY hh:mm:ss')

But the time I am getting is 12 Hour format. I want the time in 24 hour format.

What changes should I make to the above function?

anbu1984 — Fri, 02 May 2014 05:55:26 GMT

'hh:mm:ss'--->24 hrs Format

hh:mm:ss TT-->12 hrs Format

tresB — Fri, 02 May 2014 05:55:41 GMT

By default it gives 24-hour format output. Or if you are getting AM/PM in the front end, you have to SET the format in the script like:

SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]';

MK_QSL — Fri, 02 May 2014 06:10:08 GMT

Try below to get Date and Time from TimeStamp

Time

=TIME(Frac(Timestamp#(NOW(),'DD-MMM-YY hh:mm:ssTT')),'hh:mm:ss')

Date

=Date(Floor(Timestamp#(NOW(),'DD-MMM-YY hh:mm:ssTT')))

nizamsha — Fri, 02 May 2014 06:12:41 GMT

TableA:

LOAD * Inline [

Date

1-04-2014 15:15

2-05-2014 11:20

];

LOAD Date( Date#(Date,'DD-MM-YYYY h:mm'),'DD-MM-YYYY h:mm TT') as N1 Resident TableA;

Fri, 02 May 2014 10:08:21 GMT

Here you go,

Timestamp(Timestamp#(now(),'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY hh:mm:ss')

Thanks,

Prabhu