DBA > Job Interview Questions > MySQL and SQL

How do you offload the time/date handling to MyS

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you offload the time/date handling to MySQL?

SELECT DATE_FORMAT(techinterviews_timestamp, ‘%Y-%m-%d’) from techinterviews_questions; A similar TIME_FORMAT function deals with time.

(Continued on next question...)

Other Job Interview Questions