Retrieving previous month as date NOT interger

bratsela · #1 (**permalink**) 03-27-09, 05:37

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

stanislav.ondac · #2 (**permalink**) 03-31-09, 04:41

can you be more specific? put here some example

bratsela · #3 (**permalink**) 03-31-09, 05:11

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

stanislav.ondac · #4 (**permalink**) 03-31-09, 10:18

Code:

to_char(date_column,"%B")

or

Code:

to_char(date_column,"%b")

Internet Services

Web Development

Digital Marketing

Consumer Tech