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 can I do this with SQL Statements ?? I'm using Oracle 10g with functions like 'sysdate' to get the correct data since 01/01/1970... thanks for any reply... Att, Tadeu Augusto Dutra Pinto ----------------------------------------------------------------- IT Web Services ATM Cinq Technologies http://www.cinq.com.br <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq ----------------------------------------------------------------- Confiabilidade, Inovação e Qualidade em T.I.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
