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@gmail.comwrote:
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.