timestamp

[Anon]

I use timestamp as type on a colomn in a table. When I format the a result with date I always get the same date and time. It doesn't seem to work really? Does php and mysql use diffrent timestamps?

One timestamp I have in the table is
20001115214824
when I use date to format this
date("H:i - j/n",$newsValues['date'])
I get "04:14 - 19/1" as result.

TiA!

[Anon]

Yes....unix_timestamps and mysql timestamps are different formats. use the date_format() function in mysql to format your timestamps.

SELECT DATE_FORMAT(your_date_column,"%H:%i - %j/%n") AS f_date FROM your_table

fetch row and use $newValues[f_date] as the formatted value.

That's an example. check the mysql manual for all of the options. I don't think the % codes are the same in date() and DATE_FORMAT(), so you'll have to adjust.

www.mysql.com/documentation/mysql/bychapter/

Look at chapter 7, date and time functions.

---John Holmes...