[Resolved] Date

ldtiw

Hey there,

How would i change a timestamp from : 20040805042433

to something more readable?? 05-August-2004

Tried using date() but it comes out with some really random date.

Thanks,
Danny Lewin

sidney

thats not a timestamp unless its the year 2038

drawmack

sid, it's a mysql timestamp. To convert it use the UNIX_TIMESTAMP function in mysql.

ldtiw

Thanks DM.

How do i do that??

Thanks!
Dan

sidney

if you need it formatted use DATE_FORMAT function of mysql

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

if you have any probs post back one of us will im sure help you out dont foget to post the code

ldtiw

Ive tried so many times, but just cant figure it out at all. Still fairly new to this!

$row_activeusers['created'] this would be the one that needs changing.

Thanks,
Danny

sidney

no the query would need changing

SELECT DATE_FORMAT(datefieldname, '%d-%m-%Y') from table;

but with out your code and table layout cant do much more to help

ldtiw

Heres the Sql:

SELECT phpSP_users.`user`, phpSP_users.email, phpSP_users.membership_type, phpSP_users.created
FROM phpSP_users
WHERE paid = 'N'

Thanks,
Danny

sidney

 SELECT phpSP_users.`user`, phpSP_users.email, phpSP_users.membership_type, users.created , DATE_FORMAT(phpSP_users.created, '%d-%m-%Y') as formated_date 
FROM phpSP_users 
WHERE paid = 'N'

$row_activeusers['formated_date'] would then be the formated date

you could drop the users.created and rename the as dtae_formated to any name you wish and altering the $row_activeusers to

ldtiw

Thanks very much,

Sorted!