Oracle equivalent to DATEPART()?
From: John Connelly <xwhiz_at_netcom.com>
Date: Wed, 6 Jul 1994 23:03:00 GMT
Message-ID: <xwhizCsJK11.GCn_at_netcom.com>
Date: Wed, 6 Jul 1994 23:03:00 GMT
Message-ID: <xwhizCsJK11.GCn_at_netcom.com>
select datepart(hour, itemtime), count(items)
from tablename
group by datepart(hour, itemtime)
How should I do this in Oracle? Can I use casting of the timestamp?
Thanks,
John
xwhiz_at_netcom.com Received on Thu Jul 07 1994 - 01:03:00 CEST