asked on convert string to datetime in javascript
dear All
i have a string in javascript as below :
11/04/2019 17:30:00 (that represents month/day/year and time )
i need to convert this string to a datetime with the below format:
2019-11-04T17:30:00+02:00
how to do that ?
i have a string in javascript as below :
11/04/2019 17:30:00 (that represents month/day/year and time )
i need to convert this string to a datetime with the below format:
2019-11-04T17:30:00+02:00
how to do that ?
JavaScript
Last Comment
Michel Plungjan
You mean this?
Expected format: 2019-11-04T17:30:00+02:00 - but I expect +01:00 since it is not DST
https://jsfiddle.net/mplungjan/ot0xmh9s/
Expected format: 2019-11-04T17:30:00+02:00 - but I expect +01:00 since it is not DST
https://jsfiddle.net/mplungjan/ot0xmh9s/
const pad = num => ("0" + num).slice(-2);
const getFormattedDate = d => {
const tzOffsetMin = d.getTimezoneOffset(),
offsetHours = Math.floor(Math.abs(tzOffsetMin / 60)),
offsetMin = Math.abs(tzOffsetMin % 60);
let sign = "";
if (tzOffsetMin < 0) sign = "+"; // opposite of what we should think
else if (tzOffsetMin > 0) sign = "-";
// we could steal the time from the toString and replace / GMT/,""
return `${d.getFullYear()}-${pad(d.getMonth()+1)}-${pad(d.getDate())}` +
`T${pad(d.getHours())}:${pad(d.getMinutes())}:${pad(d.getSeconds())}` +
`${sign}${pad(offsetHours)}:${pad(offsetMin)}${sign===""?"Z":""}`;
}
ASKER
Expected format: 2019-11-04T17:30:00+02:00
but what i am getting from your solution is
2019-11-04T16:30:00-01:00
why?
time is 16:30 instead of 17:30 why?please explain
but what i am getting from your solution is
2019-11-04T16:30:00-01:00
why?
time is 16:30 instead of 17:30 why?please explain
ASKER
yes better to have another solution for that
something more global and not specific
in all cases thank you
something more global and not specific
in all cases thank you
Please see my updated answer.
I have written a function instead.
I still expect +01:00 and not +02:00 in Amsterdam in November
I have written a function instead.
I still expect +01:00 and not +02:00 in Amsterdam in November
something more global and not specific
That +02:00 is your original post is specific to YOUR timezone
What I post is the UTC + 00:00 : https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toISOString
You want +02:00 ?
a = new Date("11/04/2019 17:30:00");
a.setHours(a.getHours() + 2);
var d = a.toISOString().split(".")[0] + "+02:00"
That would fail across daylight saving
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi Pamela
Great you found a solution you could use.
But you did not actually use the answer you accepted as solution?
Great you found a solution you could use.
But you did not actually use the answer you accepted as solution?
Open in new window