I assume you're using Drupal 6. See the date_api.module functions like date_make_date() which will return a Date object that can be formatted with date_format_date().<div><br></div><div>Your schema type should be DATETIME or DATE <a href="http://dev.mysql.com/doc/refman/5.0/en/datetime.html">http://dev.mysql.com/doc/refman/5.0/en/datetime.html</a> </div>
<meta charset="utf-8"><div><br></div><div>You probably want to have something like this to INSERT/UPDATE the db.</div><div><br></div><div>$date_array['year'] . '-' . $date_array['month'] . '-' . $date_array['day'] . ' 00:00:00';</div>
<div><br></div><div>Then, when you SELECT the value you can do something like this.</div><div><br></div><div>$displayed_date = date_format_date(date_make_date($value, 'UTC'), 'custom', 'm/d/Y');</div>
<meta charset="utf-8"><div><div><br></div><div><meta charset="utf-8"><div>Non-language specific strings do not need to be handled with t(), too. :)</div></div><div><br></div><div>Also, is there a reason you're not using Content Profile with Date module to accomplish your task?</div>
<div><a href="http://drupal.org/project/content_profile">http://drupal.org/project/content_profile</a></div><div><a href="http://drupal.org/project/date">http://drupal.org/project/date</a></div><div><br></div><div><br><div class="gmail_quote">
On Mon, Mar 28, 2011 at 10:49 PM, Austin Einter <span dir="ltr"><<a href="mailto:austin.einter@gmail.com">austin.einter@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>After all search, I found it really difficult to deal with date. I am trying to store the date in MySql table as varchar type and placeholder as %s.</div>
<div> </div>
<div>However I need two functions to convert date from array format to string format (required while storing into table) and string format to array format (Required while showing it in form).</div>
<div> </div>
<div>The below code does that for me.</div>
<div> </div>
<div> </div>
<div><strong><em>function dateArrToStr(&$customDateArr)<br>{<br> $strDate = t($customDateArr['day']).t('- ').t($customDateArr['month']).t('-') . t($customDateArr['year']);<br> return $strDate;<br>
}</em></strong></div>
<div><strong><em></em></strong> </div>
<div><strong><em></em></strong> </div>
<div><strong><em>function dateStrToArr (&$customDateStr, $length)<br>{<br> $convDate = array();<br> $index = 0;<br> $customToken = t('');<br> $dashPosition = 0;<br> <br> for($index = 0; $index < $length; $index++)<br>
{<br> if($customDateStr[$index] == t('-'))<br> {<br> if($dashPosition == 0)<br> {<br> //Set the day<br> $dashPosition++;<br> $convDate['day'] = $customToken;<br> }<br> else if ($dashPosition == 1)<br>
{<br> //Set the month<br> $dashPosition++;<br> $convDate['month'] = $customToken;<br> }<br> $customToken = t('');<br> }<br> else<br> {<br> $customToken = t($customToken) . t($customDateStr[$index]) ;<br>
}<br> }<br> //Set year<br> $convDate['year'] = $customToken;<br> return $convDate;<br>}</em></strong></div><div><div></div><div class="h5">
<div> </div>
<div> </div>
<div>Regards</div>
<div>Austin<br><br></div>
<div class="gmail_quote">On Mon, Mar 28, 2011 at 8:36 AM, Austin Einter <span dir="ltr"><<a href="mailto:austin.einter@gmail.com" target="_blank">austin.einter@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left:#ccc 1px solid;margin:0px 0px 0px 0.8ex;padding-left:1ex" class="gmail_quote">
<div>Hi All</div>
<div>I have a date field in my form.</div>
<div>How do I store/retreive the value into/from MySQL.</div>
<div> </div>
<div>On google search, I saw people are suggesting to use either "int" or "datetime" type.</div>
<div>Please suggest which one needs to be used.</div>
<div> </div>
<div>If I use int (I hope core uses int), while storing can I just store "form['values']['date1']" as %d and while retreivin, what are the related apis to convert back to date.</div>
<div> </div>
<div>Regards</div>
<div>Austin.</div><font color="#888888">
<div> </div>
<div> </div></font></blockquote></div><br>
</div></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></div></div>