[SOLVED] Date format (should be easy)

[excl209]

Hello,

 

when I echo my date variable I get 2007-06-12 00:00:00...

 

how do I get rid of the time?  00:00:00

 

Many thanks,

excl209

[paul2463]

have a look here at the <a href="http://uk.php.net/date"> MANUAL </a> tells you how to format dates into any way you like

[mjlogan]

I would also guess you are not storing it as a timestamp.

 

the strtotime function may also be helpful.

[akitchin]

if you're pulling from a MySQL database, you can use the DATE_FORMAT() to operate directly on the column.  might as well use MySQL for what it's worth than extracting data in an unsuitable format then using PHP to parse it:

 

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html

[lewis987]

i guess youve got something like this:

 

$datetime=date("y/m/d h:i:s");

 

or:

 

date("y/m/d h:i:s");

 

try this:

 

$date=date("y/m/d");

 

just use the variable $date whereever you want the date to be

[excl209]

$date=date("y/m/d");

 

Works perfectly... thanks for your help!

 

Excl209