Computer FAQs & Tips

This is a list of handy tips that could help you in a blink on how to convert String to Date in SQL. This post cover 5 popular databases (Oracle, MySQL, DB2, PostgreSQL, Informix)

Post your comment here if you find this post useful or want to contribute more explaination.

Oracle

Syntax:

to_date(date_string, format)

Example:

SELECT user.name, user.location FROM user
WHERE user.starteddtm = to_date('20/10/2007 16:01', 'dd/mm/yyyy hh24:mi');

Read more…