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