Re: How To Extract Hour From A Date Column In A Table?

On Thu, 06 Apr 2006 06:21:38 -0700, matthew wrote:

> SQL> select extract(hour from cast(sysdate as timestamp)) from dual;
> 15

That is an unusual solution. My solution would be something like:

select to_char(sysdate,'HH24') from dual;

I like your solution better.

-- 
http://www.mgogala.com