Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    4

    Wink Unanswered: how to Get the First day of working week in informix

    Hi All,
    I'm Trying to get the First day of working Week.
    ( In my case, Sunday )

    Any suggestion ?


    Tnx.

  2. #2
    Join Date
    Jun 2008
    Posts
    8
    What exactly do you mean Goren? To perform something when the day is Sunday?

    This tutorial on date processing and this example that calculates work days might help you.

  3. #3
    Join Date
    Jul 2009
    Posts
    4
    I want to automate date selection, so I can use it in Procedures and reports.

    I need something like: MDY(MONTH(TODAY), 1, YEAR(TODAY))
    ( The first day of the current month ), but for a week.

  4. #4
    Join Date
    Jul 2009
    Posts
    37
    Are you just looking for the weekday() function?

    eg..

    select weekday(call_date), call_date
    from calls
    ;
    -- or --
    select *
    from calls
    where weekday(call_date) = 1
    ;
    -- 0 = sunday, 6 = saturday.

  5. #5
    Join Date
    Jul 2009
    Posts
    4
    Tnx a lot.

Posting Permissions

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