Chop Sting

[arun4444]

When i access the date Column in Mysql i get the following result "2007-06-16 14:02:49" What string function do i use to chop off the time,

 

I have about 5 hours of Php experience, lol i am a total noob, please help

 

ty

 

arun

[Silverado_NL]

if you create these date records yourself you should store em as UNIX Timestamps Here is a link to a short info site refering to this handy timestamp.

http://www.tizag.com/phpT/phpdate.php

 

If you dont create these timestamp you could chop it with the following function.

<?php

$datestring // lets say this is the variable holding the date like "2007-06-16 14:02:49".
$time = substr($datestring, 11, ; // this will output the part of string starting from character 11 and counting 8 character long (14:02:49) part off the string


$time // this contains "14:02:49"
?>

 

Hope this helps you

[Psycho]

You would use a combinatin of strtotime() and date().

 

date() allows you to format a date and/or time in any manner you wish. But it requires a timestamp. strtotime() converts a database date/time to a timestamp:

 

$time = "2007-06-16 14:02:49";

echo date("F j, Y", strtotime($time));

//Output: June 6, 2007

Also, here's a tutorial on the subject: http://www.phpfreaks.com/forums/index.php/topic,95430.0.html

[arun4444]

Thank You very much it worked out,

[The Little Guy]

you could also do this:

 

<?php
$fulldate = '2007-06-16 14:02:49';
list($date, $time) = explode(" ",$fulldate);

echo 'The date is: '.$date;
echo 'The time is: '.$time;
?>