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, 3462🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What Happens to an Arithmetic Operation with Two Different Data Types in SQL Server Transact-SQL? Wh...
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transac...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...