How To Convert Characters to Times?
Page 1 of 1
How To Convert Characters to Times?
by Micheal Sat Jan 16, 2010 9:20 pm
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
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
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» How To Convert Numbers to Characters?
» How To Convert Characters to Numbers?
» How To Convert Dates to Characters?
» How To Convert Characters to Dates?
» How To Convert Characters to Numbers?
» How To Convert Dates to Characters?
» How To Convert Characters to Dates?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL