Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have Julian dates in our SQL Server database.
I can convert them on the database client as well as in the script at the sql part of the script.
But I am doing two part ETL. 'Source --> Staging' and 'Staging --> Final qvd'.
So, I don't want to perform coversion on the database in the 'Source --> Staging' script.
Once the data is loaded to Staging, can I convert in the 'Staging --> Final qvd' script??
I mean without hitting the database again.
E.g:
SELECT schedwin.WO.DATECREAT, DATEADD(s, ABS(DATECREAT), '19700101') AS
Record_Create_Datetime FROM schedwin.WO
Result:
DATECREAT | Record_Create_Datetime |
---|---|
1432809061 | 2015-05-28 10:31:01.000 |
1441291351 | 2015-09-03 14:42:31.000 |
1441291952 | 2015-09-03 14:52:32.000 |
Is there any wahy to do this in QlikView script please?
Thanks
SB
These are not Julian dates. They are UNIX times, i.e. number of seconds since 1970-01-01.
Try
TimeStamp(MakeDate(1970) + DATECREAT/24/60/60) as MyDate
HIC
Hi Henric,
This is working and is really helpful.
Thank you very much for the quick answer.
Regards
SB