Re: SQL question on Dates
From: Fred Allison <fallison_at_thesysgrp.com>
Date: 1996/05/17
Message-ID: <319CDEAC.20E2_at_thesysgrp.com>#1/1
Date: 1996/05/17
Message-ID: <319CDEAC.20E2_at_thesysgrp.com>#1/1
wrote:
> How would I write the SQL to pull the current month's records without having
> to put modify the date in the criteria?
select .....
from table
where trunc(column_with_date,'MM') = trunc(sysdate,'MM')David Smith
Received on Fri May 17 1996 - 00:00:00 CEST