topic Re: Timestamp in QlikView

Timestamp

pgarcia75 — Sat, 16 Nov 2024 21:21:49 GMT

Hello

I have a MySql table with two fields: Date Msg (date type) and TimeMsg (type time).

I wish to load these two fields and create a new create with these two fields:

RDV:

LOAD
DateMsg,
TimeMsg,
Timestamp (DateMsg & '' & TimeMsg) as tsMsg;
From ...

But, it does not working
Who can help me ?
Thanks
P

anushree1 — Fri, 22 Feb 2019 11:00:57 GMT

Please use

Timestamp( FieldName ,'YYYY-MM-DD hh.mm'

Timestamp(Timestamp#(Fieldname))

pradosh_thakur — Fri, 22 Feb 2019 11:10:10 GMT

If your date and time are dates and times and not string then try

Timestamp (num(DateMsg)+ num(TimeMsg) )as tsMsg;

pgarcia75 — Fri, 22 Feb 2019 12:14:15 GMT

Thanks