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>'; 

Answer 1

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.