Fixed the timezone issue from nextJS API fetching from aws redshift
I am using Next.js to fetch the data from AWS Redshift while running query from DataGrip its showing
orderMonth | repeatC | newC
2024-02-01 | 81 | 122
2024-01-01 | 3189 |4097
But while returning from Next.js API same query returning data in timezone
orderMonth | repeatC | newC
2024-02-01T18:30:00.000Z | 81 | 122
2024-01-01T18:30:00.000Z | 3189 |4097
I tried to set timezone as well over query but its not working...
I need to have same DataGrip result from API endpoint too.
Any help will be great to identify what the exact reason behind it...
Thanks in advance.
Solution
To apply custom date time format use Custom Date/Time Formats settings in Settings | Database | Data Editor and Viewer
- How to access parent ref from child
- How do i define the fib() function, which returns the next Fibonacci number after each call?
- A returned Promise with Fetch doesn't respond to .then()
- How to trigger inline script onload?
- How to get index of an array element in click event with JavaScript
- Line 6 of this Javascript program is confusing me
- How to use Lightbox on AJAX loaded content
- How to increase quality on a PixiJS canvas?
- is it possible to install canvas with M1 chip
- Executing Javascript from Python
- regex to match HTML <p ...> tag
- How to swap two variables in JavaScript
- Primitive value vs Reference value
- Why would one use a logical AND expression (using the `&&` operator, double ampersand) as a stand-alone statement?
- Error copying 2d array contents to Google Sheets column
- how to pass values to :nth-child() css selector in cypress
- How to validate email by whitelist domain regex
- Passing checkbox value to show / hide Password via react native
- MUI with Preact & HTM No Build Setup
- Drag and drop items from different groups
- In React, what's the difference between onChange and onInput?
- Accessing http status code constants
- Next.js middleware Module not found: Can't resolve 'fs'
- How to parse JSON response in Google App Script?
- Chaining on an Array.find() in JavaScript
- NextJS - Update data object being passed into Child Component based on Button Click
- Close Modal when clicked on other div
- Convert relative path to absolute using JavaScript
- React Hook Warnings for async function in useEffect: useEffect function must return a cleanup function or nothing
- Add A Year To Today's Date