• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

milliseconds, epoch time, today's date

Guest
May 26, 2008 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

1.2K

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
community guidelines
LEGEND ,
May 26, 2008 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/

Votes

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
community guidelines
Guest
May 27, 2008 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))>

Votes

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
community guidelines
LEGEND ,
May 27, 2008 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.

Votes

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
community guidelines
Community Beginner ,
Oct 30, 2018 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>

Votes

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
community guidelines
Explorer ,
Jul 10, 2020 Jul 10, 2020

Copy link to clipboard

Copied

LATEST

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!

 

Votes

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
community guidelines
Resources
Documentation