View Single Post
  #2 (permalink)  
Old 2008-03-18, 06:11 AM
Xnuiem's Avatar
Xnuiem Xnuiem is offline
Senior Member
 
Join Date: May 2004
Location: DFW, Texas
Posts: 1,104
Xnuiem will become famous soon enough
Send a message via Yahoo to Xnuiem
Default

That is a date column, not timestamp. And sadly enough, that means just a little more work for you.

There are two ways to do this, one is using PHP. You can use the function mktime() (PHP: mktime - Manual) to plug in your output and use date() to get the exact format you want.....

Or, just use MySQL to do it. (MySQL :: MySQL 5.0 Reference Manual :: 11.6 Date and Time Functions)

So you will do something like:

select date_format('<FORMAT YOU WANT>', date_column_name) from table etc....
__________________
I rarely give code examples.
No, I have never used IIS or Windows of any kind as a web server. Get a real OS!
Please don't PM me, I won't respond.
Reply With Quote