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;