[RESOLVED] parse datetime data from mysql

[severndigital]

I have a datetime field in mysql.

i would like to retrieve it and then grab only the date to one variable and the time to another.

I'm not sure what to use, but i would want something like this.

//retrieved from mysql

$var1 = '2006-07-07 16:45:56';

// i would like to have the following result

$var2 = '2006-25-06';

$var3 = '16:45:56';

i'm sure it's very easy, i just can find the right command in php functions to do it.

thanks,

chris

[etully]

If you are certain that the date will always be in that format (with a single space in between), then the easiest method is probably something like this:

<?php
$var1 = '2006-07-07 16:45:56';
$a =explode(" ",$var1);
$var1 = $a[0];
$var2 = $a[1];

print "The date is $var1 and the time is $var2";
?>

[severndigital]

that worked excellent.

many thanks to you.

chris

[Installer]

Or do it in the query:

$query = "SELECT DATE(datetime_field) AS my_date, TIME(datetime_field) AS my_time FROM my_table";