[Resolved] date function please help!!

[hsob]

I have a date stored as yyyy/mm/dd. I have been trying for ages to change the format of the date and everything has failed for me. I know how to apply a query to change the date format but I cant seem to get that to work coz it interferes with my other sql statements.

I then decided to write this function below but this is displaying the following error on my web page:
Fatal error: Cannot redeclare gettimestamp() (previously declared in /users///public_html/cinema/owner/moviesshowing.php:99) in /users///public_html/cinema/owner/moviesshowing.php on line 99

The code is as follows:
function GetTimeStamp($MySqlDate)
{
/
Take a date in yyyy-mm-dd format and return it to the user
in a PHP timestamp
/
$date_array = explode("-",$MySqlDate); // split the array

$var_year = $date_array[0];
$var_month = $date_array[1];
$var_day = $date_array[2];

$var_timestamp = mktime(0,0,0,$var_month,$var_day,$var_year);
return($var_timestamp); // return it to the user
}

I would really really appreciate help with this? I have spend so long at it and I’ve got nowhere.
Thank you
Kind Regards.

[weekender]

it's basically saying you've already got a function with the same name, in file moviesshowing.php on line 99. This file must be included in the current script, cause the two functions are clashing (as they have the same name).

You may find it easy to use [man]strtotime[/man], which takes a textual date and returns a timestamp, which can then be re-formatted using [man]date[/man]

adam

[hsob]

Thats great thank you Adam
Im just wondering about the following:
if I use:
$sDate = "$date_begin";
print "The value is: " . date("r", strtotime($sDate));
?>

it prints out :

Fri, 2 Apr 2004 00:00:00 +0100

is there anyway that I can get rid of 00:00:00 +0100 ?

[weekender]

think you'd want

date("l jS F, Y", strtotime($sDate))

read the manual page on [man]date[/man]

adam

[hsob]

Thanks