Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: Retrieving previous month as date NOT interger

    HI there

    Can anyone please help with a function on Informix to retrieve previous month as date not interger .

    any help will be appreicated

    Regards,
    Brian

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    can you be more specific? put here some example

  3. #3
    Join Date
    Mar 2009
    Posts
    2
    cool the function " MONTH(DATE) - would return the previous month function as an interger , thus , I looking for a similar function which will return the previous month as month , as "November" instead of "11".

    let me know if you need further details

  4. #4
    Join Date
    Aug 2005
    Posts
    140
    Code:
    to_char(date_column,"%B")
    or
    Code:
    to_char(date_column,"%b")

Posting Permissions

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