[SOLVED] UK not US date?

[the_oliver]

Hello,

 

I have a date field in MySQL database.  I have to enter the date in this format: YYYY-MM-DD  so i can have the search results ordered by date.  I would however like it displaid in the uk date format DD-MM-YYYY.  How can i go about this?  Thanks!

[trq]

Take a look at the date function.

[the_oliver]

Ok, so i have go that

 

$today = date("F j, Y");
echo $today;

 

will give me the format October 15, 2006.  But i want to do this of a result stored in a database.  So i tried:

 

$time = 2007-03-07;
$today = date("F j, Y", $time);
echo $today;

 

(as 2007-03-07 is the format stored in the database)

 

But that gives me January 1, 1970 not March 7, 2007.  Where have i gone wrong??

 

Thanks.

 

[kenrbnsn]

The second parameter to the date() function is a UNIX time stamp, so you have to convert the date string to that. The easiest way is to use the strtotime() function.

<?php
$time = 2007-03-07;
$today = date("F j, Y", strtotime($time));
echo $today;
?>

 

Ken

[the_oliver]

Thanks!  Sorted it!

[mjlogan]

Side Note: Store it as a timestamp, and you can easily work with it and format it how you want.