0

I have this code currently:

   $('#cal').datepicker({
                    onSelect: function(dateText, inst) { 
      var dateAsString = dateText; //the first parameter of this function
      var dateAsObject = $(this).datepicker( 'getDate' ); //the getDate method

   }
                });

I wanted to know how I can call parseDate on dateAsObject to format it as such: YYYY/MM/DD. To store into mysql DATE field

re1man
  • 2,337
  • 11
  • 38
  • 54

2 Answers2

1

you can add this :

dateFormat: '{dateFormat}'

     $('#cal').datepicker({
         dateFormat: 'YYYY/MM/DD',
         onSelect: function(dateText, inst) { 
         var dateAsString = dateText; //the first parameter of this function

       }
     });
AlexC
  • 9,657
  • 17
  • 64
  • 98
  • 1
    I think the OP wants date in that format only to store in DB but not in the UI. By setting the dateFormat as `YYYY/MM/DD` the plugin will display the date also in that format. – ShankarSangoli Dec 14 '11 at 21:38
  • yeah, that is very true. He has a choice at least – AlexC Dec 14 '11 at 21:40
0

There is no direct date formatter in JavaScript. You can either use any jQuery plugin to format the date as per your required format or you can just use this code to get the date formatted as per your requirement.

dateAsObject.getFullYear()+"/"+(dateAsObject.getMonth()+1)+"/"+ dateAsObject.getDate()
ShankarSangoli
  • 69,612
  • 13
  • 93
  • 124
  • this works BECAUSE: getDate method returns a JavaScript Date-object, which exposes getter-functions. I like @AlexC answer better though. No need to convert from string to Date-object and back :) – supertopi Dec 14 '11 at 21:38
  • @TopiOjala - Check my comment for AlexC's answer. – ShankarSangoli Dec 14 '11 at 21:39