Another query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Another query

Post by shiznatix »

I have a bunch of records in a table with 2 rows that are in the date format YYYY-MM-DD but I would like to change these to MM/DD/YYYY. I would like to just do this in an query instead of writing a script to do it. How would I do this?
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

Post Reply