change date format in oracle query 1

change date format in oracle query

select to_char(date_column,'YYYY-MM-DD') from table;

Here is what the above code is Doing:
1. We’re using the to_char function to convert the date column to a string.
2. We’re using the ‘YYYY-MM-DD’ format to specify the format of the date.
3. We’re using the to_char function to convert the date column to a string.
4. We’re using the ‘YYYY-MM-DD’ format to specify the format of the date.

Similar Posts