Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    82

    Unanswered: Start and End date of previous month

    Hello

    I have not used INformix for mnay many months and need to know how to calculate the start and end time of the previous month

    Based on adm_date

    Can anyone help me with this?

    Kind Regards
    Helen

  2. #2
    Join Date
    Mar 2012
    Location
    Somewhere In Europe
    Posts
    24
    Hi Helen
    I'm not quit sure what you looking for bu Imho, try in this way:

    select first 100 (adm_date - day(adm_date) units day + 1 units day - 1 units month) as date_from, (adm_date - day(adm_date) units day) as date_to

    Regards
    Mike

Posting Permissions

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