Connecting Tech Pros Worldwide Forums | Help | Site Map

how to subtract month from current date

Newbie
 
Join Date: Feb 2009
Posts: 6
#1: Feb 26 '09
hi,
please tell me how to subtract month from current date.
Thanks in advance.
Vikas Jain

Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 293
#2: Feb 26 '09

re: how to subtract month from current date


Maybe like that
Expand|Select|Wrap|Line Numbers
  1. select now() - interval '1 month';
  2.  
Reply