Collections:
Convert Dates to Character Strings in Oracle
How To Convert Dates to Characters in Oracle?
✍: FYIcenter.com
You can convert dates to characters using the TO_CHAR() function as shown in the following examples:
SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') FROM DUAL; -- SYSDATE returns the current date 07-MAY-2006 SELECT TO_CHAR(SYSDATE, 'YYYY/MM/DD') FROM DUAL; 2006/05/07 SELECT TO_CHAR(SYSDATE, 'MONTH DD, YYYY') FROM DUAL; MAY 07, 2006 SELECT TO_CHAR(SYSDATE, 'fmMONTH DD, YYYY') FROM DUAL; May 7, 2006 SELECT TO_CHAR(SYSDATE, 'fmDAY, MONTH DD, YYYY') FROM DUAL; SUNDAY, MAY 7, 2006
⇒ Convert Character Strings to Dates in Oracle
⇐ Convert Character Strings to Numbers in Oracle
2020-03-25, 2623🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...