date format in node.JS

Question

I am using mysql database,in that i have a field by name request_date. The type of the field is time stamp and the data stored in this field has the format 2012-05-16 14:59:18. But when I retrieve the same data by Node.JS, the data is displayed in the browser as

Fri Jun 08 2012 15:16:50 GMT+0530 (India Standard Time)

Why this format change is happening?

I have written this query:

SELECT
biz_registration.reqid,biz_registration.request_date,biz_registration.req_status,biz_registration.annual_cost,biz_registration.rid,biz_contact.first_name,biz_contact.last_name
FROM biz_registration
INNER JOIN biz_contact ON biz_registration.reqid=biz_contact.reqid
ORDER BY biz_registration.request_date
DESC limit '+start+','+mlimit+''

the html code i am using is,

options +='<div class="column" style="background-color: #E1E1E1;width:         100px;">'+result.reqid+'</div>';
options +='<div class="column" style="background-color: #E1E1E1;width: 160px;">'+result.request_date+'</div>';

How are you converting the date from the query into a Date object in Node.JS? How are you displaying the date in HTML? The query is probably fine, this is HTML formatting or Date object creation issue. — freakish
– freakish, Commented Jun 25, 2012 at 11:01
Please post the code that you use to convert the date into a js Date object (if you do) and the code that generates the html. In js Date-objects the months start at 0. January is month 0, June is is month 5. — kioopi
– kioopi, Commented Jun 25, 2012 at 11:04
i am not doing any date object conversion.can anyone help me in doing it.thanks in advance — nithin Kumar
– nithin Kumar, Commented Jun 25, 2012 at 11:32

Fattie · Accepted Answer · 2020-10-21 14:55:05Z

34

I was having the same problem, this fixed my problem:

You need to 'force' your mysql connection to format it immediately, add this into your config(connection details):

host: 'localhost',
user: 'root'
// ....
dateStrings: 'date'

Note that in many cases

dateStrings: true

rather than 'date'

seems to be the needed solution.

edited Oct 21, 2020 at 14:55

Fattie

9,77076 gold badges455 silver badges769 bronze badges

answered Apr 5, 2015 at 13:29

Balkana

7066 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

abarisone Over a year ago

Could you please explain more your solution?

Balkana Over a year ago

I had a customer database with some orders and when I wanted to display Date of the order I would get a very long date format (example from first post) Then I was trying to find a simple solution so I can just display the actual date 'MM/dd/YYYY' and with the code from above it worked perfectly. I found that example on some other site, can't remember right now. This is how it looks at me right now: var pool = mysql.createPool({ connectionLimit : 10, host : 'localhost', user : 'root', password : 'password', database : 'database', dateStrings: 'date' });

user353885 Over a year ago

All the options from the node-mysql docs: dateStrings: Force date types (TIMESTAMP, DATETIME, DATE) to be returned as strings rather then inflated into JavaScript Date objects. (Default: false) -- I was looking for DATETIME myself

RANDRIAMILASOA Stanislas · Accepted Answer · 2016-03-01 11:21:21Z

23

This config resolve mine, according to node-mysql doc

  host: 'localhost',
  user: 'root',
  password: '',
  dateStrings:true,
  database: "mydb"

answered Mar 1, 2016 at 11:21

RANDRIAMILASOA Stanislas

9557 silver badges12 bronze badges

Comments

nithin Kumar · Accepted Answer · 2012-06-26 05:54:50Z

8

i got this working by requiring the library or module called date format. first we have to install date format package using

npm install dateformat

then u can require it in ur coding. then u can create the object of retrieved data as

var day=dateFormat(result.request_date, "yyyy-mm-dd h:MM:ss");

and print it.

answered Jun 26, 2012 at 5:54

nithin Kumar

2951 gold badge2 silver badges8 bronze badges

1 Comment

Dima L. Over a year ago

Please note that the correct format for mysql is: "yyyy-mm-dd HH:MM:ss"

M. Hamza Rajput · Accepted Answer · 2019-07-12 19:17:11Z

5

Here is the solution :

var datetme = new Date().toLocaleString();

OR

const DATE_FORMATER = require( 'dateformat' );
var datetme = DATE_FORMATER( new Date(), "yyyy-mm-dd HH:MM:ss" );

answered Jul 12, 2019 at 19:17

M. Hamza Rajput

10.5k3 gold badges53 silver badges42 bronze badges

Comments

Martin Faartoft · Accepted Answer · 2013-09-02 10:22:05Z

3

What you see, is simply the default javascript date formatting. If you want it formatted differently, you can use the methods:

getDate(): Returns the date
getMonth(): Returns the month
getFullYear(): Returns the year

on the date object, and combine the results with / or - or : to get the format you want.

Have a look at: http://www.elated.com/articles/working-with-dates/ for more details

answered Sep 2, 2013 at 10:22

Martin Faartoft

3,2852 gold badges20 silver badges11 bronze badges

Comments

Vladimir Salguero · Accepted Answer · 2021-04-14 16:06:37Z

0

Sometimes you can't get to format your date with the yyyy-mm-dd h:MM:ss (database format) just by using new Date().toLocaleString or new Date().toISOString().

To achieve this we need to add the dateformat package

npm install dateformat

Then we use

const dateFormat = require ('dateformat');

So to assign a date you can use dateFormat

var created_at = dateFormat(new Date(), 'yyyy-mm-dd h:MM:ss');

edited Apr 14, 2021 at 16:06

answered Apr 14, 2021 at 6:32

Vladimir Salguero

5,9773 gold badges49 silver badges51 bronze badges

Collectives™ on Stack Overflow

date format in node.JS

6 Answers 6

3 Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related