Hour portion of datetime field

[ekta22]

Hi,

I have a datetime field and I was to extract just the hour portion of that in my SQL statement.

Any ideas on how to do this? I tried to look around but did not find anything.

Thanks,

-E

 

[PHV]

SELECT CAST(yourDateTimeColumn AS TIME) ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Ascalonian]

Try this...

SELECT EXTRACT(HOUR FROM SYSDATE)

 

[r937]

mikey, nice ANSI

well, except for the SYSDATE ;-)

r937.com | rudy.ca