MS Access Time and Date

[Anon]

Hiya, retreiving date and time fields from a microsoft access database are stored in the following format

$date
2000-12-01 00:00:00

$time
1899-12-30 13:14:55

how can I change this so a user sees

Friday, 1st December 2000

I tried echo date ("l, nS F, Y", $date) ;

But this return 1st January 1970.

Any help will be greatfully received

Thanks !

Mark

[Anon]

The date function is expecting the second parameter to be a timestamp. It doesn't recognize your date format. You'll need to use the mktime() function with the pieces of $date to get what you want.

It takes six parameters. They are, in order:
hours, minutes, seconds, month, day, year. It's used like this.

echo ("December 1, 2000 is a " . date ("l", mktime(0,0,0,12,1,2000)));

You should be able to use either a split() or a substr() to parse out the pieces of your date format.

Hope this helps.

[Anon]

Hi,

Basically, date () needs the info in a slightly different format to understand it.

The function below might work... give it a try:

function ConvertAccessDateTime ($DateTime) {
//--- Converts a Date string (YYYY-MM-DD HH:MM:SS) to readable
//--- format

$DateTime = ereg_replace('([0-9]*)-([0-9]*)-([0-9]*)','\3 \2 \1', $DateTime);
return date ("l, nS F, Y", strtotime ($DateTime));

}