Formatting a Javascript Date for MySQL

Saturday, December 8. 2007

Formatting a Javascript Date for MySQL

I don't like to code in JavaScript, but that's the Ajax-y wave of the future. So I write it when I have to. This week I needed to format a Javascript date as a MySQL-style date like 2007-12-08.

JavaScript apparently doesn't have a nice date formatting function or even a generalized sprintf. Another Javascript quirk is that the Date.getMonth() function returns 0-11, while the getDate() function returns 1-31. I'm not sure what the designer was thinking on that one.

I came up with this function...feel free to use it in your code with or without credit:

function formatDate(date1) {

  return date1.getFullYear() + '-' +

    (date1.getMonth() < 9 ? '0' : '') + (date1.getMonth()+1) + '-' +

    (date1.getDate() < 10 ? '0' : '') + date1.getDate();

}

Posted by Mike Boone in Tech at 05:59 | Comment (1) | Trackbacks (0)

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

Nice one - thanks!

#1 waterloomatt on 2010-02-03 22:09 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	Enclosing asterisks marks text as bold (word), underscore are made via _word_. Standard emoticons like :-) and ;-) are converted to images. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above:
	Remember Information? Subscribe to this entry