Convert string to date in Oracle SQL?

Question

Aryan Kumar · Answer

Sure, here is how you can convert a string to a date in Oracle SQL:
SQL
SELECT TO_DATE('2023-07-18', 'DD-MM-YYYY');
This code will convert the string 2023-07-18 to a date in the format
DD-MM-YYYY. The TO_DATE() function takes two arguments: the string to convert and the date format. The date format is a string that specifies the format of the string to convert.
Here is a table of some of the common date formats that you can use with the 
TO_DATE() function:
Date Format
Description
DD-MM-YYYY
The day, month, and year in the format "DD-MM-YYYY".
YYYY-MM-DD
The year, month, and day in the format "YYYY-MM-DD".
MM/DD/YYYY
The month, day, and year in the format "MM/DD/YYYY".
DD Mon YYYY
The day, month abbreviation, and year in the format "DD Mon YYYY".
You can also use the TO_DATE() function to convert a string in a custom format to a date. For example, the following code converts a string in the format "YYYYMMDD" to a date:
SQL
SELECT TO_DATE('20230718', 'YYYYMMDD');
This code would also return the date 2023-07-18.
The TO_DATE() function is a powerful tool that you can use to convert different string formats into dates in Oracle. By using the
TO_DATE() function, you can ensure that your dates are stored in a consistent format.
Here are some examples of how to use the TO_DATE() function:
SQL
-- Convert a string in the format "DD-MM-YYYY" to a date.
SELECT TO_DATE('2023-07-18', 'DD-MM-YYYY');
-- Convert a string in the format "YYYY-MM-DD" to a date.
SELECT TO_DATE('20230718', 'YYYYMMDD');
-- Convert a string in a custom format to a date.
SELECT TO_DATE('01-JAN-2023', 'DD-MON-YYYY');

forum

Convert string to date in Oracle SQL?

Utpal Vishwas

Can you answer this question?

1 Answers

Liked By

Date Format	Description
`DD-MM-YYYY`	The day, month, and year in the format "DD-MM-YYYY".
`YYYY-MM-DD`	The year, month, and day in the format "YYYY-MM-DD".
`MM/DD/YYYY`	The month, day, and year in the format "MM/DD/YYYY".
`DD Mon YYYY`	The day, month abbreviation, and year in the format "DD Mon YYYY".