SQL date export format

[hopkinsc]

Hi all 

Has anyone seen a date format like this that has come out of SQL? I'm am struggling to convert it to an actual date format..

The 2nd column is manually typed to show what the date actually is. 

[Anil_Babu_Samineni]

iCreatedDate is the UNIX format or what it is?

[hopkinsc]

i'm not sure what the format is, we have a solution on how to convert it in SQL..

SELECT FORMAT(CAST(dbo.fCore_IntToDateTime(iCreatedDate) as date),'dd/MM/yyyy')

but we wanted to try and find a solution in Qlik also. 

[johnca · Accepted solution]

It looks like it might be counting in hundredths of seconds. Taking the last 2 entries, subtracting one from the other and dividing by 3 (days between dates) I get 132,285. Divide 1440 (seconds in a day) by that result and I get .01088. There is no timestamp in your  2nd column so hard to say.

HTH,

John

[Brett_Bleess]

Did John's post happen to work out?  That seems to be the most plausible explanation of things.  If that did help you get things resolved, be sure to return to the tread and use the Accept as Solution button on his post to give him credit for the assistance and let other Community Members know that was the issue etc...  If you are still trying to figure things out, I would almost say it might be wise to put a post up on the DB vendors site too in order to see if someone there can confirm things as to what that value is etc...  They would be the experts on that.  Sorry I do not have something better.

Regards,
Brett