Thread

1. Selecting weekdays from datetime

   Martin Christensen <factotum@mail1.stofanet.dk> — 2000-10-10T14:00:14Z

   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
   
   

2. Re: Selecting weekdays from datetime

   Bill Morrow <wmorrow@home.com> — 2000-10-10T14:54:10Z

   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'