Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Unanswered: Informix query to find first date of previous month

    Hi,

    I want an Informix query to find first date of previous month, ie it should calculate from the system date.


    when I run a report on any date of feb it should take 1'st Jan as the start date

    Please help me on this I am new to Informix DB

    Regards,
    Santhosh

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    MDY(month(current- 1 units month), 1,year(current- 1 units month))

    http://publib.boulder.ibm.com/infoce...c/sqls1108.htm
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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