How to fetch date from date function in javascript

Question

I need the current date so I am writing a below code

dateCreated = new Date();

which returns Thu Dec 05 2013 12:57:48 GMT+0530 (India Standard Time).

But when I am trying to store it into database it is showing an error

I am using DateTime datatype to store date in SQL Server 2012 database

I even tried using Date datatype but it is showing me error.

Is there any way to do this?

I just want to store date

try this: http://stackoverflow.com/questions/5129624/convert-js-date-time-to-mysql-datetime — miszczu, Dec 05 '13 at 09:15
@Trupti In which format you want to store date in database..? Could you please provide the format? — Vishal Patel, Dec 05 '13 at 09:16

Johnno Nolan · Answer 1 · 2013-12-05T09:26:10.140

1

You need to put it in a format that SQL understands. It doesn't understand the string Thu Dec 05 2013 12:57:48 GMT+0530 (India Standard Time) just format it how SQL likes it.

e.g. YYYY-mm-dd

edited Dec 05 '13 at 09:26

answered Dec 05 '13 at 09:19

Johnno Nolan

29,228
19
111
160

1

perhaps the Op doesn't know "how sql likes it" ;) – Abhitalks Dec 05 '13 at 09:20
1

Or just: `yyyyMMdd`. (to include time: `yyyyMMdd HH:mm:ss`) – Abhitalks Dec 05 '13 at 09:30
OP wanted the date though. Time was irrelevant. – Johnno Nolan Dec 05 '13 at 09:45

score 0 · Answer 2 · answered Dec 05 '13 at 09:51

Format the date according your need

function getDate() {  
    TDate = new Date(); 
    CurYear = TDate.getYear();
    CurMonth = TDate.getMonth();
    CurDay = TDate.getDate();
    CurHour = TDate.getHours(); 
    CurMins = TDate.getMinutes(); 
    CurSecs = TDate.getSeconds();

    CurDay = ((CurDay < 10) ? '-0' : '-') + CurDay;
    CurMins = ((CurMins < 10) ? ':0' : ':') + CurMins;
    CurSecs = ((CurSecs < 10) ? ':0' : ':') + CurSecs;

    TheDate = '';
    TheDate += ((CurYear%1900)+1900) + '-';
    TheDate += CurMonth;
    TheDate += CurDay + ' ';
    TheDate += CurHour;
    TheDate += CurMins;
    TheDate += CurSecs;
    return TheDate;
}

alert(getDate()); //YYYY-MM-DD HH:MM:SS

How to fetch date from date function in javascript

2 Answers2