milliseconds, epoch time, today's date

[Guest]

Hello:
1210921200000 is the number of milliseconds from Jan 1 1970 to a certain date/time. How do I convert that into a date/time using CF? I am sure somebody has faced this before. Thanks

[Newsgroup_User]

one way, off the top of my head, would be:
dateadd('s', 1210921200000/1000, createdatetime(1970, 1, 1, 0, 0, 0))

there are other ways. experiment with different cf date/time functions.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[Guest]

Azadi: You reply worked perfectly well. Thanks a ton.
<CFSET a = dateadd('s', #encounter_date#/1000, createdatetime(1970, 1, 1, 0, 0, 0))>

[Newsgroup_User]

worldnet5 wrote:
> Hello: 1210921200000 is the number of milliseconds from Jan 1 1970 to a
> certain date/time. How do I convert that into a date/time using CF? I am sure
> somebody has faced this before. Thanks

preserves the accuracy of the original epoch offset:

<cfscript>
aDate=createObject("java","java.util.Date").init(javacast("long",1210921200000));
writeOutput("#dateFormat(aDate)# #timeFormat(aDate)#");
</cfscript>

be aware that the datetime returned from this will be in the *server* timezone
*not* UTC.

[Benjamin Reid]

<cfscript>

CreateObject("java", "java.util.Date").from( CreateObject("java", "java.time.Instant").ofEpochMilli(JavaCast("long", 1210921200000)) )

</cfscript>

[Ripley Casdorph]

I know this is from a while ago, but I am working with some covid data coming out of a JSON string

{"OBJECTID":1,"COVID_Date":1584057600000,"Daily_Case_Count":2,"Cumulative_Case_Count":2,"Daily_Death_Count":0,"Cumulative_Death_Count":0,"UTC_Date":1584079200000}}

  and the  gross number: 1584079200000  was giving me fits!
Your string allowed me to return the right number: dateadd('s', 1584079200000/1000, createdatetime(1970, 1, 1, 0, 0, 0))

output:{ts '2020-03-13 06:00:00'}

Thanks for saving my butt!