This is really a mysql question. You should review the date section in the mysql manual: http://dev.mysql.com/doc/refman/5.1/en/datetime.html
In short: If it's just a date, then then "date" type would be the most appropriate. There are several examples on how to populate the field in that manual page. yyyy-mm-dd would work, as would yyyymmdd and a couple of other options. mysql retrieves the date field type as yyyy-mm-dd.
Ursula
On Thu, Feb 3, 2011 at 10:03 PM, mahesh gajabar mahesh143an@gmail.com wrote:
Hi, I have a form element called date in my module file like this .. $format='Y-m-d'; $form['date'] = array( '#type' => 'date_popup', '#title' => t(' Date'), '#date_format' => $format, );
date pop up Is coming fine and I can select date easily. Issue ahead me is to submit this date to database and show it in my edit form with default value which I submitted in databse. How I can submit this date to database (which is the better data type in table for this field? Is it int or date or datetime in mysql?) and retvieve it in Year-Month-date format to show on screen. I am new baby to drupal .Please help me guys.
Mahi,
-- [ Drupal support list | http://lists.drupal.org/ ]