trying to find a day :)

[slimak]

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 :)))

[Ed prochak]

"slimak" <slimak@infinity.net.pl> wrote in message news:<ca47g3$2h9$1@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

PS you are posting from Poland, right?

[slimak]

PS you are posting from Poland, right?

yes, thank you for your answer. It was useful :)

[Sybrand Bakker]

On Tue, 8 Jun 2004 13:22:19 +0200, "slimak" <slimak@infinity.net.pl>
wrote:
how can I select records from a base, when I want to find records from thepast week (monday-sunday). I work on th Oralce 9i but I work with it twoweeks only :)))


Look up the next_day function in the sql reference manual.


--
Sybrand Bakker, Senior Oracle DBA