Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am currently loading Oracle data into Qlikview, I have a date field creation_date as
1 | 1052931376000 |
2 | 1052931469000 |
3 | 1052989210000 |
4 | 1052989493000 |
5 | 1052989855000 |
6 | 1052990059000 |
Now I want to convert this into human date field into YYYYMMDD format.
I am currently using "Timestamp(MakeDate(1970) + creation_date/60/60/24) as creation_date" but output is something like this
17/02/35303 17:13:20
I want it to be YYYYMMDD format, Please advise
Thanks for your help
Why not?
Date((25569 + Round(FieldName/1000) / 86400), 'YYYYMMDD') as FieldName
Perhaps this?
Date(Date#(MakeDate(1970) + creation_date/60/60/24),'DD/MM/YYYYY hh:mm:ss'),'YYYYMMDD') as creation_date
There seems to be an error in the formula? One bracket is extra closed?
What date do you expect this to be?
1052931376000
Actually I don't know the output as I don't have direct access to the source,but for this 28799843280210 if I use
Timestamp(MakeDate(1970) + creation_date/60/60/24) as creation_date I am getting output as 17/02/35303 17:13:20
but I would except to be something like Year0217, Year may be 2016 or 2107
This returns as
=Date((25569 + Round(1052931376000/1000) / 86400), 'YYYYMMDD')
I want to achieve this in script side please
How about this?
=Timestamp(MakeDate(1970) + creation_date/60/60/24/1000)
Why not?
Date((25569 + Round(FieldName/1000) / 86400), 'YYYYMMDD') as FieldName
Thank you, I am getting output as 02/05/2003 16:13:02 but need it to be 20030502 YYYYMMDD