Home » SQL & PL/SQL » SQL & PL/SQL » query dates
query dates [message #1461] Thu, 02 May 2002 11:22 Go to next message
jpa
Messages: 1
Registered: May 2002
Junior Member
I need to create a view that will return the average number of events taking place in august. not for a specific year, for all years in the database. any suggustions?

Report message to a moderator

Re: query dates [message #1492 is a reply to message #1461] Mon, 06 May 2002 11:43 Go to previous message
Munish
Messages: 21
Registered: November 2001
Junior Member
hi..
try this

create view abc
as (select avg(events) from table
where to_char(the_date,'MON') = 'AUG');

Report message to a moderator

Previous Topic: Saving records selected by a lov
Next Topic: Re: Calculate days between dates.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 21:34:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.