how to subtract month from current date

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Vikas Jain
    New Member
    • Feb 2009
    • 6

    how to subtract month from current date

    hi,
    please tell me how to subtract month from current date.
    Thanks in advance.
    Vikas Jain
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Maybe like that
    Code:
    select now() - interval '1 month';

    Comment

    Working...