Date into time

donraja_ht · #1 (**permalink**) 07-26-10, 03:57

Hello,

can anyone let me know how to convert date into time in oracle Query, the date format is as follows 1/1/1900 9:00:00 AM out of this i just need the time 9:00 as the output

Thanks

shammat · #2 (**permalink**) 07-26-10, 04:03

Quote:

Originally Posted by donraja_ht

the date format is as follows 1/1/1900 9:00:00 AM

A "date" does not have a format. It is only formatted when it is displayed to the end-user (or are you really storing a date in a VARCHAR column?

Quote:

out of this i just need the time 9:00 as the output

See the manual for to_date()
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions180.htm#i1009324

Littlefoot · #3 (**permalink**) 07-26-10, 04:43

Actually, it is the TO_CHAR this time (as he'd like to display "time" value).

Something like

Code:

SQL> select sysdate,
  2         to_char(sysdate, 'hh24:mi:ss') just_time
  3  from dual;

SYSDATE             JUST_TIM
------------------- --------
26.07.2010 09:42:03 09:42:03

SQL>

donraja_ht · #4 (**permalink**) 07-26-10, 04:49

yes that is true Littlefoot i wanted something like this but i have modefied it cause i don't want seconds also is it possible to display AM PM as the unit

shammat · #5 (**permalink**) 07-26-10, 05:23

Quote:

Originally Posted by Littlefoot

Actually, it is the TO_CHAR this time (as he'd like to display "time" value).

Sorry, yes of course.

beilstwh · #6 (**permalink**) 07-26-10, 08:44

Quote:

Originally Posted by donraja_ht

yes that is true Littlefoot i wanted something like this but i have modefied it cause i don't want seconds also is it possible to display AM PM as the unit

Of course, simply change the format mask. Instead of "hh24:mi.ss" use "hh:mi AM"

Internet Services

Web Development

Digital Marketing

Consumer Tech