Help | Site Map

Join Bytes
Login

network: 226,223 (2692 online)

bytes

how to subtract month from current date

Vikas Jain Vikas Jain is offline

Vikas Jain is offline

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

rski is offline

Moderator

Join Date: Dec 2006

Location: Europe

Posts: 292

#2: Feb 26 '09

re: how to subtract month from current date

Maybe like that

Expand|Select|Wrap|Line Numbers

select now() - interval '1 month';

Reply

« previous question | next question »

Similar PostgreSQL Database bytes

Adding Events to Calendar (answers)
subtract one month from the current date (answers)
Calculate age / age next birthday from date of birth without using DateDiff solution (answers)
current date - 7 dayz? (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,223 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved