Highlighted

milliseconds, epoch time, today's date

New Here ,
May 26, 2008

Copy link to clipboard

Copied

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
TOPICS
Advanced techniques

Views

582

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

milliseconds, epoch time, today's date

New Here ,
May 26, 2008

Copy link to clipboard

Copied

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
TOPICS
Advanced techniques

Views

583

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
May 26, 2008 0
LEGEND ,
May 26, 2008

Copy link to clipboard

Copied

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/

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
May 26, 2008 0
New Here ,
May 27, 2008

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
May 27, 2008 0
LEGEND ,
May 27, 2008

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
May 27, 2008 0
Community Beginner ,
Oct 30, 2018

Copy link to clipboard

Copied

<cfscript>

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

</cfscript>

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 30, 2018 0
New Here ,
Jul 10, 2020

Copy link to clipboard

Copied

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!

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 10, 2020 0