SQL Transformation

[evansabres]

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 · Accepted solution]

try in QLik script

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

[neelamsaroha157]

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

[Chanty4u]

or

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

[sergio0592]

Hi try with :

load

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

[evansabres]

this also worked, thank you

[evansabres]

this also worked, thank you

[evansabres]

this also worked, thank you