Can anyone help me with converting some date values that I received in a format that is unfamiliar to me? I need to display them on the screen.
Here is an example of the format I'm dealing with:
/Date(1427982649000-0400)/
The equivalent value in the database is:
2015-04-02 09:50:49.000
I'm not sure where to even begin with this conversion process.
This timestamp is in milliseconds, along with a timezone offset from UTC.
In this case, it's UTC -4 hours, which translates to 1427982649 seconds after January 1, 1970.
For checking unix timestamps, you can use this helpful tool: (remember to convert milliseconds to seconds before inputting them)
/edit: Adding some more context - the "timezone shift" seems to adhere to RFC822 (and potentially other RFCs), where "-0400" follows the format "+/-HHMM", indicating a deviation of -04 hours, 00 minutes precisely.
When you convert the current time and date into milliseconds, it aligns with the Unix time origin of January 1st, 1970. This marks the beginning of time for Unix computers.
To reverse this conversion and obtain the actual time, various loops or conversions can be utilized based on that specific millisecond value.
Is anyone familiar with this format and how to convert it?
The string "/Date(1427982649000-0400)/" appears to be a time value in milliseconds followed by an offset in the ±HHmm format. To convert this to a Date, adjust the time value based on the offset.
If we assume the usual sign convention for offsets, then subtracting a positive offset and adding a negative one will yield the correct UTC value. A code snippet like the following should work:
var s = '/Date(1427982649000-0400)/';
// Extract numerical values
var b = s.match(/\d+/g);
// Determine the sign of the offset
var sign = /-/.test(s)? -1 : +1;
// Adjust the time value by converting the offset to milliseconds
// and use it to create a Date object
var ms = +b[0] + sign * (b[1].slice(0,2)*3.6e6 + b[1].slice(-2)*6e4);
console.log(new Date(ms).toISOString()); // 2015-04-02T17:50:49.000ZIn the given example, "2015-04-02 09:50:49.000" does not specify a timezone, meaning it represents different moments across various timezones. If the database stores this value as is, assuming the missing timezone is UTC-0800 would be logical. Storing values in UTC along with the offset is recommended to avoid ambiguity related to host timezones.
The complexity arises from ECMAScript's timezone offset convention being opposite to the standard, where west of Greenwich has positive offsets and east has negative. Therefore, applying this convention, "/Date(1427982649000-0400)/" translates to 2015-04-02T09:50:49.000Z, which may align with your requirements.
If that's the case, simply modify the line:
var sign = /-/.test(s)? -1 : +1;
to
var sign = /-/.test(s)? +1 : -1;
My task is to create a form with an input field and a dropdown list containing options for Checkbox and Radio. The user should enter text in the input field and select a type from the dropdown. For example: Input field: One, Two, Three Radio The expecte ...
I have a unique react blog application embedded with a form for submitting intriguing blog posts. The setup includes a server, routes, model, and controllers for fetch requests. Surprisingly, everything functions impeccably when tested on Postman. However, ...
Is there a way to position a pop-up at the bottom right corner of the window? I have code that centers the pop-up in the window, but I'm looking to place it specifically at the bottom right corner. $(id).css('top', winH - $(id).height()); ...
I'm encountering an issue when trying to deploy my project on the server. Everything runs smoothly on my PC with no import problems. Thank you for your assistance! Error Message: Error [ERR_MODULE_NOT_FOUND]: Module '/home/igor/backend/alina_edu ...
When I receive code through AJAX, I handle it as shown below: $verifiedSubject = addslashes(htmlentities($_REQUEST['subject'])); $verifiedBody = addslashes(htmlentities($_REQUEST['body'])); $verifiedAttachment1 = addslashes(htmlentitie ...
I've been struggling with adding a property to a nested Object in my JavaScript code. Despite setting the property name and value, the property doesn't seem to persist. populated_post.comments[i].comment.end = true console.log(typeof(populated_po ...
As I delve into the world of front-end web development, I decided to challenge myself with a little exercise by creating a basic HTML form. <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta ...
Years ago, before the advent of React, I mastered linking events to tables by attaching the listener to the <tbody> and extracting the true source of the event from the event target. This method allowed for a single listener for the entire table, as ...
I am struggling with posting data obtained from an html form created in a jsp file using javascript and sending it to a java class after validating the form data. I was exploring alternatives to Ajax since I am not well-versed with those tools, but if you ...
I have a JavaScript function that extracts the values of multiple checkboxes and stores them in an array: var selectedValues = $('.item:checked').map(function(){return parseInt($(this).attr('name'));}).get(); My goal is to pass this a ...
In my form, I have two fields - carriercode and billnum. I want to ensure that the value in the billnum field always starts with the carriercode as a prefix. For example, if carriercode=ABCD, then billnum should start with ABCD followed by any combination ...
A recent challenge arose when attempting to utilize two different versions of an API. The approach involved checking for a 404 error with version v2, and if found, falling back to version v1. The plan was to create separate async thunk actions for each ver ...
I've encountered an issue with handling the on-click event of a button in the following code snippet: $(document).on("click", '.submit_review_button', function(event, ui) { var place = $.data(this, "object"); var ttext = $("#revie ...
Hey there, I seem to be encountering an issue that states: Cannot read properties of undefined (reading 'split'). I came across this error message in the console https://i.sstatic.net/3nICv.png Upon clicking the link to the error, it directs me ...
I am working on a system for selecting items and need assistance with iterating through a table one item at a time upon clicking a button. Currently, the button only displays the first item in the table. How can I modify it to cycle through each item one b ...
Recently, I have been utilizing a method to download PDF files from the server using Laravel 8 (API Sanctum) and Vue 3. In my Vue component, I have implemented a function that allows for file downloads. const onDownloadDocument = (id) => { ...
Encountering an error: Error: Module 'jquery' not found in path 'F:...\newstyle\assets\lib\helper\html\img\js' at C:\Users...\AppData\Roaming\npm\node_modules&bs ...
In my React project, I'm using axios with React.StrictMode enabled by default, causing components to render twice. To handle this behavior, I've set up an abort control for my axios instance and call its abort() method in the useEffect clean-up f ...
I'm attempting to create a unique scrollable chips array using Material UI version 4 (not version 5). Previous examples demonstrate similar functionality: View Demo Code I would like to update the scrolling bar of this component to include l ...
I have been encountering an issue while using DataTable serverside processing. My datatable includes an edit column, and when the edit link is clicked, a jQuery dialog box appears. After submitting the dialog box, an ajax.reload call is made. However, the ...