How to get datetime in 24hour format from oracle database?
oracle10g
Solution
select to_char(col_name, 'yyyy-mm-dd hh24:mi:ss') from tab_name
You can read more about `to_char` function here
Problem
Is there any other way to get datetime field from oracle database in 24hour format???like -> "select getxsddate(col_name) from tab_name" will get you datetime format as "2012-04-04T12:31:00"...I wanted to know if there are any other ways as i`m not satisfied with this format.