Re: Selecting weekdays from datetime

Поиск
Список
Период
Сортировка
Искать

Re: Selecting weekdays from datetime

От:
Bill Morrow <wmorrow@home.com>
Дата:
Martin Christensen wrote:
> 
> Howdy,
> 
> I have a database of mailing list entries where I would like to do
> some statistics on activity on different days of the week. So say I
> want to do something along the hypothetical lines of
> 
> SELECT COUNT(*) FROM table WHERE day_of_week(date) = 'Mon'
> 
> how do I go about doing that?
> 
> Martin
> 

I believe

select count(*) from table where where to_char(day, 'Day') =
'Monday   '

should do it. Note the three space pad on the end of
'Monday   ' 
to make it the same length as 'Wednesday'

Selecting weekdays from datetime

От:
Martin Christensen <factotum@mail1.stofanet.dk>
Дата:
Howdy,

I have a database of mailing list entries where I would like to do
some statistics on activity on different days of the week. So say I
want to do something along the hypothetical lines of

SELECT COUNT(*) FROM table WHERE day_of_week(date) = 'Mon'

how do I go about doing that?

Martin

-- 
GPG public key: http://home1.stofanet.dk/factotum/gpgkey.txt
FAQ