<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV></DIV>
<DIV>The value is returned as an associative array, with keys of "year," "month," and "day." Each value is a string, but they are validated to ensure they are numeric, etc. You will have to massage the array data into whichever format you want. That is a simple task, but if you use the Unix timestamp format, watch out for timezone issues. As for which data type to use in the database, a lot depends on what date ranges you anticipate using, and how you want to use them. Typically Drupallers use the Unix timestamp, but that hits its limit in 2038 (much like the dreaded Y2K issues 11 years ago). BTW, the Date module does not guard against this.</DIV>
<DIV> </DIV>
<DIV>Retrieving that data is going to be the same process in reverse. Drupal has the useful date_format() function, but that only works on Unix timestamps (maybe this will change in D8). PHP itself has several ways to deal with date formats, but does not provide translation as Drupal's function does.<BR> </DIV>
<P><FONT color=#ff007f size=4 face="bookman old style, new york, times, serif"><EM><STRONG>Nancy</STRONG></EM></FONT></P>
<P> </P>
<P><FONT face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</FONT></P>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR><FONT size=2 face=Tahoma>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<HR SIZE=1>
</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> mahesh gajabar</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"></FONT><BR>Hi,<BR>I have a form element called date in my module file like this ..<BR> $format='Y-m-d';<BR> $form['date'] = array(<BR> '#type' => 'date_popup',<BR> '#title' => t(' Date'),<BR> '#date_format' => $format,<BR>);<BR><BR>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.</DIV></DIV></div></body></html>