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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 6 Apr 2006 08:09:35 -0400
Message-ID: <AYudnSpkHNqcmKjZnZ2dnUVZ_tSdnZ2d@comcast.com>

"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message news:pan.2006.04.06.05.02.49.277800_at_sbcglobal.net...
: 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
:

it also will not extract the hour... was your tongue firmly planted in your cheek or did someone decaffeinate your coffee? ;-)

++ mcs Received on Thu Apr 06 2006 - 07:09:35 CDT