Re: SQL question on Dates
From: DPepa <dpepa_at_aol.com>
Date: 1996/05/17
Message-ID: <4nh0gm$4nj_at_newsbf02.news.aol.com>#1/1
Date: 1996/05/17
Message-ID: <4nh0gm$4nj_at_newsbf02.news.aol.com>#1/1
>How would I write the SQL to pull the current month's records without
having
>to put modify the date in the criteria? Therefore on the first of the
month
>it would automatically reset to pulling just that month's records.
select * from my_table
where to_char(sysdate,'mmyyyy') = to_char(my_date,'mmyyyy')
Received on Fri May 17 1996 - 00:00:00 CEST