Collections:
Convert Character Strings to Dates in Oracle
How To Convert Character Strings to Dates in Oracle?
✍: FYIcenter.com
You can convert dates to characters using the TO_DATE() function as shown in the following examples:
SELECT TO_DATE('07-MAY-2006', 'DD-MON-YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('2006/05/07 ', 'YYYY/MM/DD') FROM DUAL; 07-MAY-06 SELECT TO_DATE('MAY 07, 2006', 'MONTH DD, YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('May 7, 2006', 'fmMONTH DD, YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('SUNDAY, MAY 7, 2006', 'fmDAY, MONTH DD, YYYY') FROM DUAL; 07-MAY-06
⇒ Convert Times to Character Strings in Oracle
⇐ Convert Dates to Character Strings in Oracle
2020-03-25, 2131🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...