Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to write below SQL statement in Qliksense load script.
"if cast (to_char(((create_tms at time zone 'UTC') at time zone site.timezone_id), 'HH24MISS') as integer) between 000000 and 040000
then trunc(((o.created_at at time zone 'UTC') at time zone site.timezone_id))-1
else trunc(((o.created_at at time zone 'UTC') at time zone site.timezone_id)) end as lu_date"
Can someone please help me to write this into Qlik sense?
Thanks in advance.
I am not good at SQL but this part ((create_tms at time zone 'UTC') at time zone site.timezone_id) is confusing to me, what are you expecting for that section?
Hi Digvijay,
Thank you for quick reply.
It converts the corresponding datetimeoffset value in the target time zone.
you can refer below link.
https://docs.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql?view=sql-server-ver15
Thanks.