ChatGPT解决这个技术问题 Extra ChatGPT

Convert a Unix timestamp to time in JavaScript

I am storing time in a MySQL database as a Unix timestamp and that gets sent to some JavaScript code. How would I get just the time out of it?

For example, in HH/MM/SS format.

Just multiply by 1000 since JS timestamps are in milliseconds and PHP delivers in seconds.
Here is a very useful link with different date format: timestamp.online/article/… Combine with the multiplication by 1000 and it gets the job done!
See this how I have achieved: stackoverflow.com/a/64089456/2927228
If you have a string in a different date format, see Parsing a string to a date in JavaScript.
dt=new Date(1234567890 * 1000).toLocaleString(); gives date+time — or use .toLocaleDateString() or .toLocaleTimeString())

l
leonheess

let unix_timestamp = 1549312452 // Create a new JavaScript Date object based on the timestamp // multiplied by 1000 so that the argument is in milliseconds, not seconds. var date = new Date(unix_timestamp * 1000); // Hours part from the timestamp var hours = date.getHours(); // Minutes part from the timestamp var minutes = "0" + date.getMinutes(); // Seconds part from the timestamp var seconds = "0" + date.getSeconds(); // Will display time in 10:30:23 format var formattedTime = hours + ':' + minutes.substr(-2) + ':' + seconds.substr(-2); console.log(formattedTime);

For more information regarding the Date object, please refer to MDN or the ECMAScript 5 specification.


@nickf multiplications are trivial on modern CPUs - the string concatenation will require a lot more work!
Actually it will display time in '10:2:2' format, since it does not add an extra 0 before values below 10.
@user656925 - Multiplication involves numbers, concatenation involves strings. Computers handle numbers far more efficiently than strings. When string concatenation is done, there's a lot of memory management going on in the background. (However, if you're already doing a string concatenation anyway, then including a few extra characters in one of the strings might actually be less costly on average than the one processor op it takes to multiply two numbers together.)
@Stallman number computation is the most fundamental thing that computers do, and they're extremely efficient at it, both in memory and runtime. Brilliand's comment above is relevant, although IMHO the very final part of his comment is completely bogus.
@Stallman It's true of all languages (or nearly all, in theory an exotic language could be created that isn't like this - but all the common ones are). A string is stored internally as a pointer to a block of memory where the contents of the string are stored. The pointer itself uses the same amount of memory as most numbers do on the same system, and the memory to store the actual strings is in addition to that. Then when you concatenate the strings, you're most often creating a brand-new string with the combined contents of both strings.
p
pitust

function timeConverter(UNIX_timestamp){ var a = new Date(UNIX_timestamp * 1000); var months = ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec']; var year = a.getFullYear(); var month = months[a.getMonth()]; var date = a.getDate(); var hour = a.getHours(); var min = a.getMinutes(); var sec = a.getSeconds(); var time = date + ' ' + month + ' ' + year + ' ' + hour + ':' + min + ':' + sec ; return time; } console.log(timeConverter(0));


for HH/MM/SS just use last three variables and this is time will be in your local time but if you want to get the UTC time just use the getUTC methods. Here's the code.
I used this solution but tweaked it so that minutes and seconds would show up as :03 or :09 instead of :3 or :9, like so: var min = a.getMinutes() < 10 ? '0' + a.getMinutes() : a.getMinutes(); var sec = a.getSeconds() < 10 ? '0' + a.getSeconds() : a.getSeconds();
Bug: getMonth() returns a month number between 0 and 11, thus a.getMonth() - 1 is wrong.
Don't need a list of month names, javascript has that, even in IE. var month = a.toLocaleDateString(undefined, {month: 'short'})
n
nicael

JavaScript works in milliseconds, so you'll first have to convert the UNIX timestamp from seconds to milliseconds.

var date = new Date(UNIX_Timestamp * 1000);
// Manipulate JavaScript Date object here...

D
Dan Alboteanu

Use:

var s = new Date(1504095567183).toLocaleDateString("en-US")
console.log(s)
// expected output "8/30/2017"  

and for time:

var s = new Date(1504095567183).toLocaleTimeString("en-US")
console.log(s)
// expected output "3:19:27 PM"

see Date.prototype.toLocaleDateString()


This is a command to get the date (M/D/YYYY), not the time (HH/MM/SS) as requested.
just a note, the number "1504095567183" is unix_timestamp * 1000
In addition, toLocaleString includes both date and time.
V
VisioN

Modern Solution (for 2020)

In the new world, we should be moving towards the standard Intl JavaScript object, that has a handy DateTimeFormat constructor with .format() method:

function format_time(s) { const dtFormat = new Intl.DateTimeFormat('en-GB', { timeStyle: 'medium', timeZone: 'UTC' }); return dtFormat.format(new Date(s * 1e3)); } console.log( format_time(12345) ); // "03:25:45"

Eternal Solution

But to be 100% compatible with all legacy JavaScript engines, here is the shortest one-liner solution to format seconds as hh:mm:ss:

function format_time(s) { return new Date(s * 1e3).toISOString().slice(-13, -5); } console.log( format_time(12345) ); // "03:25:45"

Method Date.prototype.toISOString() returns time in simplified extended ISO 8601 format, which is always 24 or 27 characters long (i.e. YYYY-MM-DDTHH:mm:ss.sssZ or ±YYYYYY-MM-DDTHH:mm:ss.sssZ respectively). The timezone is always zero UTC offset.

This solution does not require any third-party libraries and is supported in all browsers and JavaScript engines.


I'm pasting your function in Chrome's console :/ Even in your fiddle it's showing 01:02:00 for me ! Tried on Firefox, same results. Very strange...I'm pretty sure it's because I'm GMT+1 !
I've offered an edit for your answer that ignores any timezone, so it'll always show the right formatted value !
@SteveChamaillard Thank you, Steve. You were right, toTimeString was not working well with time zones. Unfortunately your edit was rejected before I saw it. However, I'd suggest to use toISOString instead, since toGMTString is deprecated and may return different results on different platforms.
Even shorter with ES6: let time = s => new Date(s * 1e3).toISOString().slice(-13, -5)
Both aren't working in Safari iOS 13 using the timestamp from navigator.geolocation
B
Brad Koch

I'm partial to Jacob Wright's Date.format() library, which implements JavaScript date formatting in the style of PHP's date() function.

new Date(unix_timestamp * 1000).format('h:i:s')

I know It was good answer back in a days, but this days extending native js objects is an anti-pattern.
It doesn't work (anymore?) in node js format is not a function. But this apparently works: stackoverflow.com/a/34015511/7550772
@ibodi it's library
P
Peter Mortensen

I'd think about using a library like momentjs.com, that makes this really simple:

Based on a Unix timestamp:

var timestamp = moment.unix(1293683278);
console.log( timestamp.format("HH/mm/ss") );

Based on a MySQL date string:

var now = moment("2010-10-10 12:03:15");
console.log( now.format("HH/mm/ss") );

another advantage of moment.js (or similar libs) would be their support of relative time, for messages like "6 hours ago".
In your console.log examples, I was confused about the format due to the /, but it helped me a lot.
My timestamp is in UTC format. Any change I need to make here for that? How can I have am/pm?
moment.js is waaay overkill for such a small thing to do and will affect your performance. Use native methods instead, cf. Dan Alboteanu's answer
L
Luis David

shortest one-liner solution to format seconds as hh:mm:ss: variant:

console.log(new Date(1549312452 * 1000).toISOString().slice(0, 19).replace('T', ' ')); // "2019-02-04 20:34:12"


when using this with PHP unix timestamps i get +5h than the actual time for some reason :/
@keanu_reeves - sounds like you are in eastern US time zone and the timestamps are UTC. Try removing the .slice(0,19) and I think you will see the timezone of the result is Z (Zulu).
g
garritfra

In moment you must use unix timestamp:

const dateTimeString = moment.unix(1466760005).format("DD-MM-YYYY HH:mm:ss");

j
james ace

This works with PHP timestamps

var d = 1541415288860; //var d =val.timestamp; //NB: use + before variable name var date = new Date(+d); console.log(d); console.log(date.toDateString()); console.log(date.getFullYear()); console.log(date.getMinutes()); console.log(date.getSeconds()); console.log(date.getHours()); console.log(date.toLocaleTimeString());

var d =val.timestamp;
var date=new Date(+d); //NB: use + before variable name

console.log(d);
console.log(date.toDateString());
console.log(date.getFullYear());
console.log(date.getMinutes());
console.log(date.getSeconds());
console.log(date.getHours());
console.log(date.toLocaleTimeString());

the methods above will generate this results

1541415288860
Mon Nov 05 2018 
2018 
54 
48 
13
1:54:48 PM

There's a bunch of methods that work perfectly with timestamps. Cant list them all


k
kapa

UNIX timestamp is number of seconds since 00:00:00 UTC on January 1, 1970 (according to Wikipedia).

Argument of Date object in Javascript is number of miliseconds since 00:00:00 UTC on January 1, 1970 (according to W3Schools Javascript documentation).

See code below for example:

    function tm(unix_tm) {
        var dt = new Date(unix_tm*1000);
        document.writeln(dt.getHours() + '/' + dt.getMinutes() + '/' + dt.getSeconds() + ' -- ' + dt + '<br>');

    }

tm(60);
tm(86400);

gives:

1/1/0 -- Thu Jan 01 1970 01:01:00 GMT+0100 (Central European Standard Time)
1/0/0 -- Fri Jan 02 1970 01:00:00 GMT+0100 (Central European Standard Time)

P
Peter Mortensen

Using Moment.js, you can get time and date like this:

var dateTimeString = moment(1439198499).format("DD-MM-YYYY HH:mm:ss");

And you can get only time using this:

var timeString = moment(1439198499).format("HH:mm:ss");

Do you know how to do it backwards, like converting this format DD-MM-YYYY HH:mm:ss to something like this 1439198499 ??
Hi Kemat, You can do it via this statement moment('2009-07-15 00:00:00').unix()
My timestamp is in UTC format. Any difference I need to make here for that? How can I have am/pm?
You can easily convert timestamp to date usign momentJS, you checkout this coderszine.com/convert-timestamp-to-date-using-javascript
B
Bernie

The problem with the aforementioned solutions is, that if hour, minute or second, has only one digit (i.e. 0-9), the time would be wrong, e.g. it could be 2:3:9, but it should rather be 02:03:09.

According to this page it seems to be a better solution to use Date's "toLocaleTimeString" method.


for most web solutions, this is the most correct answer, since it uses the client's locale, e.g. 24h vs. 12h am/pm format. For a time string, you would then use: date.toLocaleTimeString()
It will not happen with toTimeString method. Check here: stackoverflow.com/a/35890537/1249581.
l
leonheess

Another way - from an ISO 8601 date.

var timestamp = 1293683278; var date = new Date(timestamp * 1000); var iso = date.toISOString().match(/(\d{2}:\d{2}:\d{2})/) alert(iso[1]);


I get "Object ... has no method 'toISOString'"
My timestamp is in UTC format. Any difference I need to make here for that? How can I have am/pm?
B
Basj

Based on @shomrat's answer, here is a snippet that automatically writes datetime like this (a bit similar to StackOverflow's date for answers: answered Nov 6 '16 at 11:51):

today, 11:23

or

yersterday, 11:23

or (if different but same year than today)

6 Nov, 11:23

or (if another year than today)

6 Nov 2016, 11:23

function timeConverter(t) {     
    var a = new Date(t * 1000);
    var today = new Date();
    var yesterday = new Date(Date.now() - 86400000);
    var months = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];
    var year = a.getFullYear();
    var month = months[a.getMonth()];
    var date = a.getDate();
    var hour = a.getHours();
    var min = a.getMinutes();
    if (a.setHours(0,0,0,0) == today.setHours(0,0,0,0))
        return 'today, ' + hour + ':' + min;
    else if (a.setHours(0,0,0,0) == yesterday.setHours(0,0,0,0))
        return 'yesterday, ' + hour + ':' + min;
    else if (year == today.getFullYear())
        return date + ' ' + month + ', ' + hour + ':' + min;
    else
        return date + ' ' + month + ' ' + year + ', ' + hour + ':' + min;
}

l
leonheess
function getTIMESTAMP() {
  var date = new Date();
  var year = date.getFullYear();
  var month = ("0" + (date.getMonth() + 1)).substr(-2);
  var day = ("0" + date.getDate()).substr(-2);
  var hour = ("0" + date.getHours()).substr(-2);
  var minutes = ("0" + date.getMinutes()).substr(-2);
  var seconds = ("0" + date.getSeconds()).substr(-2);

  return year + "-" + month + "-" + day + " " + hour + ":" + minutes + ":" + seconds;
}

//2016-01-14 02:40:01

Works fine. Thank you
P
Peter Mortensen

The modern solution that doesn't need a 40 KB library:

Intl.DateTimeFormat is the non-culturally imperialistic way to format a date/time.

// Setup once
var options = {
    //weekday: 'long',
    //month: 'short',
    //year: 'numeric',
    //day: 'numeric',
    hour: 'numeric',
    minute: 'numeric',
    second: 'numeric'
},
intlDate = new Intl.DateTimeFormat( undefined, options );

// Reusable formatter
var timeStamp = 1412743273;
console.log( intlDate.format( new Date( 1000 * timeStamp ) ) );

Regarding "the non-culturally imperialistic way": Don't you mean "the non-culturally and non-imperialistic way"?
Unfortunately this method is not compatible with Safari.
T
TechWisdom

Pay attention to the zero problem with some of the answers. For example, the timestamp 1439329773 would be mistakenly converted to 12/08/2015 0:49.

I would suggest on using the following to overcome this issue:

var timestamp = 1439329773; // replace your timestamp
var date = new Date(timestamp * 1000);
var formattedDate = ('0' + date.getDate()).slice(-2) + '/' + ('0' + (date.getMonth() + 1)).slice(-2) + '/' + date.getFullYear() + ' ' + ('0' + date.getHours()).slice(-2) + ':' + ('0' + date.getMinutes()).slice(-2);
console.log(formattedDate);

Now results in:

12/08/2015 00:49

F
Fireblaze
// Format value as two digits 0 => 00, 1 => 01
function twoDigits(value) {
   if(value < 10) {
    return '0' + value;
   }
   return value;
}

var date = new Date(unix_timestamp*1000);
// display in format HH:MM:SS
var formattedTime = twoDigits(date.getHours()) 
      + ':' + twoDigits(date.getMinutes()) 
      + ':' + twoDigits(date.getSeconds());

I don't think you need an extra, separate function, to get a number with trailing zero, whenever this is necessary -- see my answer at the bottom.
@trejder, in your example, you DUPLICATE the logic while with extra function you have it in one place. Also you trigger date functon (e.g. getHours()) always two times while here - it is one time call. You can never know how heavy is some library function to be re-executed (however i do believe it is light for dates).
P
Paul Rumkin

function getDateTimeFromTimestamp(unixTimeStamp) { let date = new Date(unixTimeStamp); return ('0' + date.getDate()).slice(-2) + '/' + ('0' + (date.getMonth() + 1)).slice(-2) + '/' + date.getFullYear() + ' ' + ('0' + date.getHours()).slice(-2) + ':' + ('0' + date.getMinutes()).slice(-2); } const myTime = getDateTimeFromTimestamp(1435986900000); console.log(myTime); // output 01/05/2000 11:00


This is not an Unix Timestamp: 1435986900000 / This is an Unix Timestamp: 1435986900
this solution works for me but how can i take the month like Feb Mar Apr instead of number ?
J
John Slegers

You can use the following function to convert your timestamp to HH:MM:SS format :

var convertTime = function(timestamp, separator) {
    var pad = function(input) {return input < 10 ? "0" + input : input;};
    var date = timestamp ? new Date(timestamp * 1000) : new Date();
    return [
        pad(date.getHours()),
        pad(date.getMinutes()),
        pad(date.getSeconds())
    ].join(typeof separator !== 'undefined' ?  separator : ':' );
}

Without passing a separator, it uses : as the (default) separator :

time = convertTime(1061351153); // --> OUTPUT = 05:45:53

If you want to use / as a separator, just pass it as the second parameter:

time = convertTime(920535115, '/'); // --> OUTPUT = 09/11/55

Demo

var convertTime = function(timestamp, separator) { var pad = function(input) {return input < 10 ? "0" + input : input;}; var date = timestamp ? new Date(timestamp * 1000) : new Date(); return [ pad(date.getHours()), pad(date.getMinutes()), pad(date.getSeconds()) ].join(typeof separator !== 'undefined' ? separator : ':' ); } document.body.innerHTML = '

' + JSON.stringify({
    920535115 : convertTime(920535115, '/'),
    1061351153 : convertTime(1061351153, ':'),
    1435651350 : convertTime(1435651350, '-'),
    1487938926 : convertTime(1487938926),
    1555135551 : convertTime(1555135551, '.')
}, null, '\t') +  '
';

See also this Fiddle.


s
shomrat
function timeConverter(UNIX_timestamp){
 var a = new Date(UNIX_timestamp*1000);
     var hour = a.getUTCHours();
     var min = a.getUTCMinutes();
     var sec = a.getUTCSeconds();
     var time = hour+':'+min+':'+sec ;
     return time;
 }

P
Peter Mortensen

See Date/Epoch Converter.

You need to ParseInt, otherwise it wouldn't work:

if (!window.a)
    window.a = new Date();

var mEpoch = parseInt(UNIX_timestamp);

if (mEpoch < 10000000000)
    mEpoch *= 1000;

------
a.setTime(mEpoch);
var year = a.getFullYear();
...
return time;

C
Community

Shortest

(new Date(ts*1000)+'').slice(16,24)

let ts = 1549312452; let time = (new Date(ts*1000)+'').slice(16,24); console.log(time);


B
Bhaumik Mehta
function getDateTime(unixTimeStamp) {

    var d = new Date(unixTimeStamp);
    var h = (d.getHours().toString().length == 1) ? ('0' + d.getHours()) : d.getHours();
    var m = (d.getMinutes().toString().length == 1) ? ('0' + d.getMinutes()) : d.getMinutes();
    var s = (d.getSeconds().toString().length == 1) ? ('0' + d.getSeconds()) : d.getSeconds();

    var time = h + '/' + m + '/' + s;

    return time;
}

var myTime = getDateTime(1435986900000);
console.log(myTime); // output 01/15/00

x
xgqfrms

moment.js

convert timestamps to date string in js

https://momentjs.com/

moment().format('YYYY-MM-DD hh:mm:ss');
// "2020-01-10 11:55:43"

moment(1578478211000).format('YYYY-MM-DD hh:mm:ss');
// "2020-01-08 06:10:11"



S
Shahnad

Try this :

      new Date(1638525320* 1e3).toISOString()  //2021-12-03T09:55:20.000Z

can you explain how does it work? what is 1e3 and why we multiple it?
S
Saitejareddy

There are multiple ways to convert unix timestamp to time (HH/MM/SS)

Using new Date() - this is in-built in javascript moment package - this is a famous node module, but this is going to deprecate. dayjs package - this is one of the latest and fast growing node module

Using new Date()

const dateTimeStr = new Date(1504052527183).toLocaleString()
const result = (dateTimeStr.split(", ")[1]).split(":").join("/")
console.log(result)

Using moment

const moment = require('moment')
const timestampObj = moment.unix(1504052527183);
const result = timestampObj.format("HH/mm/ss")
console.log(result);

Using day.js

const dayjs = require('dayjs')
const result = dayjs(1504052527183).format("HH/mm/ss")
console.log(result);

you can check the timestamp to time conversion with an online time conversion tool


P
Peter Mortensen

If you want to convert Unix time duration to real hours, minutes, and seconds, you could use the following code:

var hours = Math.floor(timestamp / 60 / 60);
var minutes = Math.floor((timestamp - hours * 60 * 60) / 60);
var seconds = Math.floor(timestamp - hours * 60 * 60 - minutes * 60 );
var duration = hours + ':' + minutes + ':' + seconds;

for timestamp=1592426697 gives wrong number of hours (=442340) - can you fix it?
t
tivoni

Code below also provides 3-digit millisecs, ideal for console log prefixes:

const timeStrGet = date => { const milliSecsStr = date.getMilliseconds().toString().padStart(3, '0') ; return `${date.toLocaleTimeString('it-US')}.${milliSecsStr}`; }; setInterval(() => console.log(timeStrGet(new Date())), 299);