milliseconds, epoch time, today's date

5 replies
1366 views
Translate

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

Advanced techniques

This topic is closed to new replies. Start a new post to keep the conversation going.

Ripley Casdorph

Participating Frequently

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!

Translate

B

Benjamin Reid

Participating Frequently

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

</cfscript>

Translate

N

Newsgroup_User

Inspiring

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.

Translate

N

Newsgroup_User

Inspiring

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/

Translate

A

Anonymous

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

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.