topic Re: TimeStamp# wont work in App Development

TimeStamp# wont work

Saif1 — Mon, 31 Oct 2022 08:09:48 GMT

I have a timestamp want to change it into a date

MY_DATE : 2010-03-29 09:47:30

am using this in load editior :

date(floor(Timestamp#(MY_DATE,'YYYY-MM-DD hh:mm:ss')),'YYYY-MM-DD') as NEW_DATE

This gives me a " - " in the model viewer any help ? am i getting the format wrong ?

MendyS — Mon, 31 Oct 2022 08:21:57 GMT

Try this -
Date(Floor(Timestamp(Timestamp#(MY_DATE,'YYYY-MM-DD hh:mm:ss')))) as NEW_DATE

Saif1 — Mon, 31 Oct 2022 08:33:19 GMT

it did not work, i dont seem to know why,

in my oracle query it is written like this ( to_char(my_Date , 'YYYY-MM_DD HH24:Mi:SS') my_date

and when i try to change it in oracle (to_Date) it gives random dates

does it affect the casting to timestamp in qlik ?

MendyS — Mon, 31 Oct 2022 08:39:26 GMT

first, you can make quick tests on the UI of the expression

second, can you send a screenshot from the data model viewer on this field? I want to see which format QLIK gives to this field...

vinieme12 — Mon, 31 Oct 2022 08:50:37 GMT

The field "MY_DATE" is already formatted as timestamp in the database

so if your load statements looks like below, then you won't need to reformat it

Table:

Load

Date(floor(MY_DATE)) as new_Date

,dim1,dim2

;

SQL Select MY_DATE,dim1,dim2 from somedbtable;

if you are converting the MY_DATE field as To_Char() in your SQL, only then you would need to convert it

Table:

Load

Date(floor(timestamp#(MY_DATE,'format'))) as new_Date

,dim1,dim2

;

SQL Select to_char(MY_DATE,'format'),dim1,dim2 from somedbtable;

Saif1 — Mon, 31 Oct 2022 09:17:21 GMT

the problem was from the oracle query itself, i fixed it then it worked in qlik , thanks all

pradosh_thakur — Mon, 31 Oct 2022 09:22:36 GMT

1: Load "MY_DATE" as it is in the Qlik load query

2: print in a textbox/ kpi/ filter

3: try printing floor(MY_DATE) if it is a number floor it and apply date

4: if floor() doesn't work try date(floor(Timestamp#(text(MY_DATE),'YYYY-MM-DD hh:mm:ss')),'YYYY-MM-DD')