WORKS PERFECT!
Thanks Brad!
-afan
> afan@xxxxxxxx wrote:
>> hi,
>> $date = "January 8 2007 11:23 pm";
>> and have to store it on db in datetime column as yyyy-mm-dd HH:ii:ss.
>> Is there any function that will "translate" $date in format I
>> need to store it in DB?
>>
>> Right now I was thinking to do like this:
>>
>> $date_new = explode(' ', $date);
>> switch($date_new[0])
>> {
>> case 'January':
>> $month = '01';
>> break;
>>
>> case 'February':
>> $month = '02';
>> break;
>>
>> // etc.
>> }
>>
>> $date_time = explode(':', $date_new[3]); $hours =
>> ($date_new[4] == 'pm') ? ($date_time[0] + 12) : $date_time[0]
>> ; $time_new = $hours.':'.$date_time[1].':00';
>>
>> $date_final = $date_new[2].'-'.$month.'-'.$date_time[1].' '.$time_now;
>>
>> Is there better solution than this above?
>>
>> Thanks.
>>
>> -afan
>
>
> strtotime() will convert your date string into a unix time format (int)
>
> Then you can use the date() function to format it properly. Make sure the
> date value is enclosed in quotes (like a text string) when inserting into
> your database.
>
> Example:
>
> $date = "January 8 2007 11:23 pm";
> $mysqldate = date("Y-m-d H:i:s", strtotime($date));
>
> $query = "INSERT INTO `datefield` VALUES '$mysqldate'"; ...
>
> Hope that helps,
>
> Brad
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
