一定期間

  • 2011/03/09(水) 18:41:30

?
SELECT
    *
FROM
    テーブル名
WHERE
    REPLACE_datetime < '2011-04-01 0:0:0.0'
AND
    REPLACE_datetime > '2011-03-01 0:0:0.0'

?
SELECT
    *
FROM
    テーブル名
WHERE
    to_char(REPLACE_datetime,"YYYYMM") = "201103"
GROUP BY
    to_char(REPLACE_datetime,"YYYYMM")


まぁ?のほうが楽だな。