Re: Re: mysql timestamp and php date

No problem! Refresh MY memory here.. I noticed you didn't return the DATE_FORMAT column "AS <var>" .. is that working okay? I seemed to think that it returned a long unwieldy column name.. maybe things are good.. let me know :-D --Jason Bryan Koschmann - Gkt wrote:

Hi Jason, I had come across this earlier, and while I can get it to return perfectly, I was more looking for something that I could do without having to pull 2 queries. Err, well wait, I wouldn't have to would I? I have 4 columns: idnum, title, date, news I was just doing a select * from newlist, but I suppose I can just address each specifically: select idnum, title, DATE_FORMAT(date, '%W, %M %D \@ %h:%i%p'), news from newslist right? Okay that works. (don't mind me talking to myself) Thanks for the help, and making me take a second to look further at it! Bryan On Mon, 30 Sep 2002, Jason Young wrote: |In my pages, I just format the date from the SQL query: | |"SELECT DATE_FORMAT(last_modified, '%m/%d/%Y %h:%i:%s %p') AS |last_modified (...)" | |Look up the DATE_FORMAT on mysql.com to get a list of the arguments. | |Hope this helps! |-Jason |