how do you reformat system date in MySQL? Explain various formats? how to add a date/hour/minute/?

Question

in mySQL

thanks

Answer 1

to format a date

"SELECT DATE_FORMAT(NOW(), '%M %e, %Y - %r) as todaysDate";

would be August 3, 2007 - 09:16:35

datetime formats are YYYY-MM-DD HH:MM:SS
use your standard INSERT and UPDATE commands to enter a date. To add a date to another date (say to make a deadline) use DATE_ADD(yourdate, INTERVAL whatyouwant added) ie 1 MINUTE, 3 12 DAY_HOUR (3 1/2 days)

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html is all the functions and the values to put into a DATE_FORMAT()

Answer 2

Take a look at this link