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

On Wed, 05 Apr 2006 14:41:10 -0700, cdavis10717 wrote:

> SELECT extract(hour from my_date_column 'HH24') as TheHour from
> my_table;

This will not give you a syntax error:

SELECT 'extract(hour from '||my_date_column||' HH24)' as TheHour from my_table;

-- 
http://www.mgogala.com