Back Home
  • Examples
  • Sample Database
#1
SELECT STR_TO_DATE('21,5,2013','%d,%m,%Y');
#2
SELECT STR_TO_DATE('21,5,2013 extra characters','%d,%m,%Y');
#3
SELECT STR_TO_DATE('2013','%Y');
#4
SELECT STR_TO_DATE('113005','%h%i%s');
#5
SELECT STR_TO_DATE('11','%h');
#6
SELECT STR_TO_DATE('20130101 1130','%Y%m%d %h%i') ;
Table List
customers
SELECT * FROM customers;
employees
SELECT * FROM employees;
offices
SELECT * FROM offices;
orderdetails
SELECT * FROM orderdetails;
orders
SELECT * FROM orders;
payments
SELECT * FROM payments;
productlines
SELECT * FROM productlines;
products
SELECT * FROM products;
  • SQL Query
Execute
Clear Beautify Minify
  • Result