Using sysdate on Oracle 10g

2008-04-22 Thread Tadeu Augusto Dutra Pinto
Hi people... I'm not an expert in SQL statements, and I'd like to get some suggestions about a search that I wanted to do on a table... I would like to get all records that are less than current date (ex: 22/04/2008) and more than the first day of the current month (ex: 01/04/2008)... How

Re: Using sysdate on Oracle 10g

2008-04-22 Thread Grooms, Frederick W
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Tuesday, April 22, 2008 8:46 AM To: arslist@ARSLIST.ORG Subject: Using sysdate on Oracle 10g ** Hi people... I'm not an expert in SQL statements