How to convert datetime64 in javascript?

Question

0.00/5 (No votes)

See more:

Hello,
Can someone tell me how to convert DateTime64(6,UTC) into Date or readable string in javascript. Let's suppose I have Int64 value 637453206453037910 (precision 6, UTC) so how to convert

637453206453037910

in the proper datetime string.
Thanks,

What I have tried:

console.log(new Date(637453206453037910))

Posted 31-Mar-21 2:44am

zeeShan anSari

Updated 31-Mar-21 5:20am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2021-03-31T05:20:00

Solution 1

Quote:
JavaScript stores dates as number of milliseconds since January 01, 1970, 00:00:00 UTC (Universal Time Coordinated).

So you need to subtract the number of ticks between Jan 1 0000 and Jan 1 1970 and then convert the result into milliseconds.

JavaScript

// NB a tick is commonly 100 nanoseconds 
var epoch = 621355968000000000;   // ticks up to Jan 1 1970
var tdate = 637453206453037910;   // the date in ticks
var dt = td - epoch;              // rebase to Jan 1 1970
var millisec = dt / 10000;        // convert to milliseconds
var d = new Date(millisec);       // create a Javascript Date object

Posted 31-Mar-21 5:20am

Richard MacCutchan

Updated 31-Mar-21 5:58am

v3

Comments

zeeShan anSari 31-Mar-21 18:01pm

Nice explanation...Its work. thanks!

Maciej Los 1-Apr-21 6:47am

5ed!

Richard MacCutchan 1-Apr-21 7:02am

Thanks. Fortunately .NET made it easy to find the answer.

zeeShan anSari 19-Apr-21 11:56am

It converts up to 3 precision but I need up to 6 precision. What should I do.

Richard MacCutchan 19-Apr-21 12:20pm

Sorry, I do not understand.

zeeShan anSari 19-Apr-21 12:37pm

My input is 637532118000166280 and your suggested formula is return 2021-04-05 05:30:00.016000 but I need 2021-04-05 09:30:00.016628. Actual code:
// NB a tick is commonly 100 nanoseconds
var epoch = 621355968000000000; // ticks up to Jan 1 1970
var tdate = data; // the date in ticks
var dt = tdate - epoch; // rebase to Jan 1 1970
var millisec = dt/10000; // convert to milliseconds
var d = new Date(millisec); // create a Javascript Date object

return moment(d).format("YYYY-MM-DD hh:mm:ss.SSSSSS");

Thanks for your quick response.

Richard MacCutchan 20-Apr-21 3:24am

The calculated time is correct, and is the time as a UTC value. If you want it as local time then you need to add the timezone offset.