Al Programming
Free source code programming in C#, VB.Net, Java, SQL
Search This Blog
Friday, February 18, 2011
Extract hour, minute from date column Oracle
Oracle >
Extract hour, minute from date column
SELECT
to_char
(
column_date
,
'HH24'
)
hh
,
to_char
(
column
,
'mi'
)
min
from
table
;
Newer Post
Older Post
Home