echo odbc_result($rs,'date_of_birth');
$dob = strtotime(odbc_result($rs,'date_of_birth'));
echo $dob;

 
    list($date, $time) = explode(' ', odbc_result($rs, 'date_of_birth'));
 
    list($year, $month, $day) = explode('-', $date);
    list($hour, $minute, $second) = explode(':', $time);
 
    echo mktime($hour, $minute, $second, $month, $day, $year);

You need to update PHP I reckon. Unless it's a platform issue, which you using access suggests it may be.

If the dates are in a regular format in the database it's probably going to be easiest to write your own function to convert them to timestamps. Why the fuck are they in the db as strings in the first place? -_-

Where does it fail? there's nowt in that that should fail except perhaps mktime. But if that's it then that's some fucking bullshit and you should complain.

But anyway, surely there's a query you can use to get the date out as you want it if it's stored as a date object thing?

Is there a specific reason why you can't upgrade PHP? I've just tested the code on PHP 5 here on Windows and it works fine.

If it's the easy PHP installation you're after, it's not all that hard to create your own set up routine for Apache and PHP.

why not make your own timestamp?

like [year][month][day][hour][minute][second][millisecond?]

2007042600153500

for 12:15:35.00 AM on 26th April, 2007.

Granted, it would require twice the storage of a unix timestamp in an INT, but it's even more flexible.

i.e. it would work :).