[RESOLVED] prob with date format coming out wrong

VisionsOfCody

I've got a line in a page that updates the "last-visit" field in the database

the db field is a timestamp(14) type

the query is this :

"UPDATE client SET client_visit=NOW() WHERE client_id='$client_id'";

this is ok because it enters 20060503174158 in the db

then i'm using this code to try to turn it back into a human readable date :

date("d-m-Y", $datestamp)

but the problem is that it just outputs '19-01-2038'

so there's definitely something wrong but i can't see what i need to do to turn 20060503174158 into 03-05-2006

can anyone help, please ?

laserlight

You may be able to do something like:

$query = "SELECT DATE_FORMAT(`client_visit`, '%d-%m-%Y')
	FROM `client`
	WHERE `client_id`='$client_id'";

If not, you can format using substr()

$datetime = '20060503174158';
$formatted_date = substr($datetime, 6, 2)
	. substr($datetime, 4, 2)
	. substr($datetime, 0, 4);

VisionsOfCody

I went for the second solution which is probably less elegant than the first - but i couldn't get my head round how to integrate that bit of code into the rest.

now it works fine

thanks once again