Collections:
Convert Character Strings to Times in Oracle
How To Convert Character Strings to Times in Oracle?
✍: FYIcenter.com
You can convert dates to characters using the TO_CHAR() function as shown in the following examples:
SELECT TO_CHAR(TO_DATE('04:49:49', 'HH:MI:SS'), 'DD-MON-YYYY HH24:MI:SS') FROM DUAL; -- Default date is the first day of the current month 01-MAY-2006 04:49:49 SELECT TO_CHAR(TO_TIMESTAMP('16:52:57.847000000', 'HH24:MI:SS.FF9'), 'DD-MON-YYYY HH24:MI:SS.FF9') FROM DUAL; 01-MAY-2006 16:52:57.847000000 SELECT TO_CHAR(TO_DATE('69520', 'SSSSS'), 'DD-MON-YYYY HH24:MI:SS') FROM DUAL; 01-MAY-2006 19:18:40
⇒ What Is NULL Value in Oracle
⇐ Convert Times to Character Strings in Oracle
2019-12-02, 1308👍, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...