Results 1 to 2 of 2

Thread: select entries from whole week

  1. 10-20-2004, 01:26 PM #1
    hudo
    hudo is offline Registered User
    Join Date
    Jun 2004
    Posts
    19

    select entries from whole week

    Hello,

    I'd like to get all entries from "the whole week" (begin: Monday end: Sunday)
    from e.g the day sysdate - 222 (today: 20.10.2004) .This means all entries with a date between 08.03.2004
    and 14.03.2004 (including the borders !)
    Reply With Quote Reply With Quote
  2. 10-21-2004, 07:32 PM #2
    acadet
    acadet is offline Registered User
    Join Date
    Oct 2004
    Location
    Australia
    Posts
    1
    Use the next_day function. ie

    SELECT trunc(next_day(SYSDATE - 7,'MONDAY')), trunc(next_day(SYSDATE,'SUNDAY')) FROM dual
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules