Converts a value to a target type (with date format style).
Syntax
CONVERT(data_type, expr [, style])Example
Enter values below to update the example in real time.
order_date→date_str→orders→SELECT CONVERT(VARCHAR(10), order_date, 120) AS date_str
FROM orders;