inserting date into mysql

[bopritchard]

i realize i shouldn't be having this much trouble with this but....

i'm just inserting a row into a mysql table...the date is in the format mm/dd/yyyy and of mysql wants it as yyyy/mm/dd

what's the easiest way to handle this...
mysql function on the insert statement?
php function?

thanks

 

[sleipnir214]

I'd handle it in PHP.

This code:

<?php

$a = '12/13/2004';

print substr($a, 6, 4) . '-' . substr($a, 0, 2) . '-' . substr($a, 3, 2);

?>

Outputs:

2004-12-13







Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[kenrbnsn]

I'd use strtotime() and date()

$date = '12/13/2004';
$mysql_date = date('Y-m-d',strtotime($date));

Ken