Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Need to convert the following oracle queries to MYSQL queries.


select to_char(to_date(?,'DD-MM-YY')) 
from dual;


select to_char(next_day(to_date(?,'DD-MM-YY'),'FRIDAY')) 
from dual;


select to_char(to_date(?,'DD-MM-YY'),'DAY') 
from dual;
share|improve this question
Read this: Date and Time Functions. But you need to convert data, too, not only queries. But you need to convert data/table-structure, too, not only queries. –  ypercube Jul 12 '12 at 13:32
the oracle to_char function without a second argument (the format string) formats a date value depending on settings on your database server and client that are not known to us. to what format do you want the date values be converted? –  miracle173 Aug 9 '12 at 5:54
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.