extract month from current_date in postgresql

[Vikas Jain]

Hi,
please tell me how to subtract month from current_date in postgresql.
Thanks in advance.
Vikas Jain

[JosAH]

Hi,
please tell me how to subtract month from current_date in postgresql.
Thanks in advance.
Vikas Jain

Do you have a java.sql.Date object? If so, its parent class (an ordinary java.util.Date) has a getMonth() method.

kind regards,

Jos

[Vikas Jain]

Thanks Sir,i got the point.