topic Re: SQL Transformation in QlikView

SQL Transformation

evansabres — Tue, 31 Jul 2018 17:16:16 GMT

I have a field from a SQL data load called po.created_date. This field is formatted as YYYY-MM-DD HH:MM:SS.

I just want the date from this field. How can I do this in the script?

Chanty4u — Tue, 31 Jul 2018 17:18:58 GMT

try in QLik script

date(date#(Field,'YYYY-MM-DD HH:MM:SS'),'DD-MM-YYYY') as YourDate

neelamsaroha157 — Tue, 31 Jul 2018 17:19:46 GMT

try Date(floor(Num(YourDateField)), 'DateFormat')

Chanty4u — Tue, 31 Jul 2018 17:19:49 GMT

date(date#(po.created_date,'YYYY-MM-DD HH:MM:SS'),'Here your Date format') as po.created_dateNew

sergio0592 — Tue, 31 Jul 2018 17:21:14 GMT

Hi try with :

load

timestamp(timestamp#(po.created_date,'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')

evansabres — Tue, 31 Jul 2018 17:23:13 GMT

this also worked, thank you

evansabres — Tue, 31 Jul 2018 17:23:17 GMT

this also worked, thank you

evansabres — Tue, 31 Jul 2018 17:23:23 GMT

this also worked, thank you