Collections:
Convert Times to Character Strings in Oracle
How To Convert Times to Character Strings 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, 'HH:MI:SS') FROM DUAL; 04:49:49 SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS.FF') FROM DUAL; -- Error: SYSDATE has no fractional seconds SELECT TO_CHAR(SYSTIMESTAMP, 'HH24:MI:SS.FF9') FROM DUAL; 16:52:57.847000000 SELECT TO_CHAR(SYSDATE, 'SSSSS') FROM DUAL; -- Seconds past midnight 69520
⇒ Convert Character Strings to Times in Oracle
⇐ Convert Character Strings to Dates in Oracle
2019-12-02, 1788🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...