'SQL에서 날짜(date)처리 방법

*****************************************************************************************************

  SELECT price, pubdate

  FROM titles

  WHERE pubdate between 'Oct 21 1998 00:00' and 'Oct 21 1998 23:59'

  SELECT price, pubdate

  FROM titles

  WHERE pubdate like 'Oct 21 1998%'

  SELECT price, pubdate

  FROM titles

  WHERE cast (pubdate as char(11)) = 'Oct 21 1998'

  SELECT price, pubdate

  FROM titles

  WHERE datepart(mm, pubdate) = 10 and

                   datepart(dd, pubdate) = 21 and

                   datepart(yy, pubdate) = 1998

   SELECT price, pubdate

  FROM titles

  WHERE pubdate between 'Oct 21 1998' and dateadd(day, 1, 'Oct 21 1998')

  SELECT datepart(month, pubdate), count(title_id)

  FROM titles

  GROUP BY datepart(month, pubdate)

  SELECT price, pubdate

  FROM titles

  WHERE pubdate between 'Oct 21 1998' and dateadd(day, 1, 'Oct 21 1998')

  SELECT datepart(month, pubdate), count(title_id)

  FROM titles

  GROUP BY datepart(month, pubdate)