Comment enregistrer la date de date picker dans une base de donn

<?php

/**
 * 
 * Implements hook_permissions.
 */

function demande_permission(){
    return array(
        'submit_demande' =>array(
            'title'=>t('submit_demande'),
            'description'=>t('submit the demande'),
        ),
    );
}



/**
 * Implements hook_menu().
 */


function demande_menu(){
    $items=array();

    $items['demande page']=array(

'title' => 'Demande de congé',
'description'=>'ajout de nouvelles demandes',
'page callback'=>'drupal_get_form',
'page arguments'=>array ('demande_showdemandeForm'),
'access callback'=>'user_access',
'access arguments'=>array('submit demande'),
'type'=>  MENU_NORMAL_ITEM      );


    return $items;
}

function demande_showdemandeForm($form, &$form_state ){



    $form['Nom'] = array(

  '#type' => 'textfield', 

  '#title' => t('Nom'), 

   '#size' => 60, 

  '#maxlength' => 128, 

  '#required' => TRUE,

);



    $form['Prénom'] = array(

  '#type' => 'textfield', 

  '#title' => t('Prénom'), 

   '#size' => 60, 

  '#maxlength' => 128, 

  '#required' => TRUE,

);




     $form['Téléphone'] = array(

  '#type' => 'textfield', 

  '#title' => t('Téléphone'), 

   '#size' => 60, 

  '#maxlength' => 128, 

  '#required' => TRUE,

);


    $form['Fonction'] = array(

  '#type' => 'textfield', 

  '#title' => t('Fonction'), 

   '#size' => 60, 

  '#maxlength' => 128, 

  '#required' => TRUE,

);
    
$form['Raison'] = array(

  '#type' => 'textfield', 

  '#title' => t('Raison'), 

   '#size' => 60, 

  '#maxlength' => 128, 

  '#required' => TRUE,

);



    

    drupal_add_library('system','ui.datepicker');
  drupal_add_js('jQuery(document).ready(function(){jQuery( ".pickadate" ).datepicker({
      dateFormat: "yy-mm-dd",
      autoSize: true
    });});', 'inline');

  $form['Date de la demande'] = array(
    '#type' => 'textfield',
    '#title' => t('Date de la demande:'),
    '#size' => 10,
    '#maxlength' => 10,
    '#attributes' => array('class' => array('pickadate')),

  );

    drupal_add_library('system','ui.datepicker');
  drupal_add_js('jQuery(document).ready(function(){jQuery( ".pickadate" ).datepicker({
      dateFormat: "yy-mm-dd",
      autoSize: true
    });});', 'inline');

  $form['textaje'] = array(
    '#type' => 'textfield',
    '#title' => t('Date début:'),
    '#size' => 10,
    '#maxlength' => 10,
    '#attributes' => array('class' => array('pickadate')),

  );

  drupal_add_library('system','ui.datepicker');
  drupal_add_js('jQuery(document).ready(function(){jQuery( ".pickadate" ).datepicker({
      dateFormat: "yy-mm-dd",
      autoSize: true
    });});', 'inline');

  $form['Date fin'] = array(
    '#type' => 'textfield',
    '#title' => t('date fin:'),
    '#size' => 10,
    '#maxlength' => 10,
    '#attributes' => array('class' => array('pickadate')),

  );






    $form['submit'] = array(
        '#type' => 'submit',
        '#value' => t('confirmer'),


        );
    


    $form['Reset'] = array(
        '#type' => 'button',
        '#value' => 'Annuler',

        );


 return $form;



}


/**
 *  Validation handler for the demande form.
 */
function demande_showdemandeForm_validate($form, &$form_state){

    if(!is_numeric($form_state['values']['Téléphone']) ){
        form_set_error('Téléphone', t('Veuillez entrer un numéro valide'));
        RETURN False;

    }
     RETURN true;

}

    /**
     * Submit handler for the demande .Inserts entry into the database.
     */

function demande_showdemandeForm_submit($form, &$form_state){
    $De_id= db_insert('demande')
            
            ->fields(array(
                'Nom' => $form_state['values']['Nom'],
                'Prénom' => $form_state['values']['Prénom'],
                'Téléphone' => $form_state['values']['Téléphone'],
                'Fonction' => $form_state['values']['Fonction'],
                'Raison' => $form_state['values']['Raison'],
                'Date_de_la_demande' => $form_state['values']['Date_de_la_demande'],
                'Date_début' =>$form_state['values']['Date_début'],
                'Date_fin' =>$form_state['values']['Date_fin'],
                ))
            
            ->execute();
     
    


}
?>