[support] How to store/retreive date fields into/from MySql

[Austin Einter]

Hi All
I have date field, I am storing it as "int" in table.
When I checked the table in database, the value shows as 1.

My code is as below.

*'INSERT INTO {rs_table} ( uid, name, qualification, email, altemail, phone,
altphone, dob, yrsofexp, prefworkloc) '
      ."VALUES (%d, '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%s')",
     $user->uid,
     $form_state['values']['persname'],
     $form_state['values']['hqualif'],
     $form_state['values']['email'],
     $form_state['values']['altemail'],
     $form_state['values']['phone'],
     $form_state['values']['altphone'],
    $form_state['values']['birthdate'],
    $form_state['values']['yearsexp'],
    $form_state['values']['prefloc']
  );*

Whats the wrong here, is there any API I have to make use of to convert from
date to int value??

Regards
Austin



On Mon, Mar 28, 2011 at 8:36 AM, Austin Einter <austin.einter at gmail.com>wrote:

> Hi All
> I have a date field in my form.
> How do I store/retreive the value into/from MySQL.
>
> On google search, I saw people are suggesting to use either "int" or
> "datetime" type.
> Please suggest which one needs to be used.
>
> 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.
>
> Regards
> Austin.
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110328/9a275dac/attachment.html