Tell me more ×
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.
up vote 3 down vote favorite

Need to convert the following oracle queries to MYSQL queries.

1)

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

2)

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

3)

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.