I have this date
Sep 7, 2019, 1:00 PM CEST
and want to convert it into a timestamp.
How would I go about doing this?
-
1Date.parse() is returning NaN unfortunatelyjrocc– jrocc2019-09-07 03:05:03 +00:00Commented Sep 7, 2019 at 3:05
-
yes directly, it won't be useful - that's why I removed the comment - writing an answer though :)H S– H S2019-09-07 03:06:42 +00:00Commented Sep 7, 2019 at 3:06
-
Okay thank you for the help!jrocc– jrocc2019-09-07 03:09:21 +00:00Commented Sep 7, 2019 at 3:09
-
1Try this, new Date("Sep 7, 2019, 1:00 PM CEST".replace('CEST', '(CEST)'))Casper– Casper2019-09-07 03:14:14 +00:00Commented Sep 7, 2019 at 3:14
-
Worked perfectly thank you if you want to write it as an answer ill give you the checkjrocc– jrocc2019-09-07 03:18:56 +00:00Commented Sep 7, 2019 at 3:18
|
Show 2 more comments
4 Answers
Replace CEST -> (CEST) and try to convert like below,
new Date("Sep 7, 2019, 1:00 PM CEST".replace('CEST', '(CEST)'))
Solution implemented based on this valuable article. Credit goes to article author :)
9 Comments
Prasad Telkikar
Hi @casper, Can you explain reason behind changing
CEST to (CEST). It works perfectly fine but how?
H S
it is not a proper conversion - the converted value is not equal to the original string
Casper
@PrasadTelkikar I referred this article to address this problem. According to article, timezone name need to wrap in parentheses flaviocopes.com/javascript-dates
Prasad Telkikar
Good article to understand
Date in javascript. +1 for articleCasper
@PrasadTelkikar Yeah, I've included article in the answer.
|
This answer is more of a pseudo-code then an exact javascript code.
The format of the string (posted by OP) is not supported natively. One of the answers used moment's moment function with second argument to parse the timezone i.e. CEST part in the querying string basically, but I found that conversion faulty too - https://www.epochconverter.com/timezones?q=1567841400&tz=Europe%2FBerlin - wondering what is 1567841400 try running this answer - https://stackoverflow.com/a/57830429/7986074
So the code would look like this -
- Extract the time-zone attribute from the string - i.e.
CEST- one may use''.substr - Convert the extracted time-zone string to the UTC offset.
- Use the UTC offset to make the date string.
- Parse the string so made with utilities such as
Dateormoment
Comments
Did you try passing that string directly into the Date constructor? But before you have to get rid of the timezone. Here is an easy example:
// 1. A variable with your date as a string literal
const dateStr = "Sep 7, 2019, 1:00 PM CEST"
// 2. Get rid of the timezone and use the result to instantiate a new date
const d = new Date(dateStr.slice(0,-4))
// 3. Now that you have your date instance, use getTime() method to get the timestamp
const timestamp = d.getTime()
Hope my answer can help you!
1 Comment
RobG
This likely changes the timezone of the date so that the time value is different.
You might need to convert your CEST to GMT+0200 which contains the timezone and the offset as well.
const date = new Date('Sep 7, 2019, 1:00 PM CEST'.replace('CEST', 'GMT+0200'));
console.log(date);4 Comments
RobG
For me this produces 2019-09-07T03:00:00.000Z which is incorrect. CEST is +2, so it should produce 2019-09-07T11:00:00Z. I suspect that moment.js is ignoring the timezone abbreviation in the timestamp. Also, an answer should not rely on a library that isn't tagged or mentioned in the OP.
fyasir
@RobG I tried the accepted answer which also produces 2019-09-07T03:00:00.000Z. I might be wrong by the question didn't mention that you can't use momentjs.
RobG
It's a convention of SO not to do so to prevent multiple (effectively identical) answers with different libraries. Anyway, moment.js doesn't help in this case.
fyasir
@RobG thanks for enlightening those issues. I removed the moment library and also found native date requires timezone+offset to convert to utc. I updated my answer. you can have a look.