From: "Aaron Wolski" <[EMAIL PROTECTED]>
> Having a brain laps and not sure where in the manual to look and sadly I
> need a QUICK solution.
> I have a date formatted in a table like: 20030826132457
> Now.. I went to MySQL timestamp from UNIX timestamps because I like the
> readability of them when just looking at the Tables. How would I format
> the date something like: August 26, 2003??
> I could easily do this with a UNIX timestamp.. not sure if the same is
> possible with this type of timestamp. Also.. I can't use the MYSQL
> functions to format the data into a UNIX TimeStamp. not int his query.

How about using DATE_FORMAT() in your query to format the date? It works
almost the same way as date() in PHP.

If not, run the date through strtotime() and then use date() to format it.

---John Holmes...

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to