Re: trying to find a day :)
Date: 8 Jun 2004 11:12:03 -0700
Message-ID: <4b5394b2.0406081012.127c96ad_at_posting.google.com>
"slimak" <slimak_at_infinity.net.pl> wrote in message news:<ca47g3$2h9$1_at_serwer.infinity.net.pl>...
> how can I select records from a base, when I want to find records from the
> past week (monday-sunday). I work on th Oralce 9i but I work with it two
> weeks only :)))
Look up the TO_CHAR() function and the data formats in the SQL manual. There is a format which specifies the day of the week. And you will need to read up on date arithmetic, in particular, what happens when you find the difference between two dates (IOW, perform a subtraction of one date from another).
That will get you moving in the right direction. In general, ORACLE's documentation is very good, so read it whenever you can.
HTH,
Ed
[Quoted] PS you are posting from Poland, right? Received on Tue Jun 08 2004 - 20:12:03 CEST