Formatting MYSQL date value

SELECT date_format
( dt, '%m/%d/%Y %T' ) as my_date FROM dt_tb

CREATE TABLE dt_tb ( id int(2) NOT NULL auto_increment, dt datetime NOT NULL default '0000-00-00 00:00:00', dt2 date NOT NULL default '0000-00-00', PRIMARY KEY (id) ) TYPE=MyISAM;

# # Dumping data for table `dt_tb` #

INSERT INTO dt_tb VALUES (1, '2004-10-26 00:00:00', '2005-01-25');
INSERT INTO dt_tb VALUES (2, '2004-05-05 23:56:25', '2005-06-12');
INSERT INTO dt_tb VALUES (3, '2005-12-08 13:20:10', '2005-06-06');

Date & Time functions used in Query for MySQL Table Getting formatted date value from date field in MySQL date_add function to calculate date & time of MySQL table Formatting date and time before adding to date field of MySQL String data to Date & time Format by using str_to_date Formatting string data stored in varchar field to date value Automatically updating / inserting current date and time value in a DATETIME field Records of each day by using group by command Collecting records between two date ranges from MySQL table fields Getting date values from MYSQL table in readable format including time Difference in days between two date fields Getting the year part from date field Getting the month part from date field Getting the day part from date field Records of today or records of last X seconds by using curdate() or unix_timestamp Records of last one month from today by using date field Records of present week days by using dayofweek function