DATETIME calculation

15 pts.
Tags:
DateTime
Development
SQL
Hi there, this is probably very simple but i just can't get it working. I want to subtract one month from a variable month. So if the datetime variable is equal to 10 Feb 2008 the result should be 10 Jan 2008. Please help. Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

You did not mention which database system you’re using, and this is an important item of information, as all of them seem to have a different set of date functions.

The <b>standard SQL </b> way of doing it is with [i]intervals[/i] –

SELECT foo FROM bar WHERE datecolumn = CURRENT_DATE – INTERVAL 1 MONTH

MySQL supports this, as do several others.

In Microsoft SQL Server, you have to use the proprietary GETDATE and DATEADD functions –

SELECT foo FROM bar WHERE datecolumn = DATEADD(MONTH,-1,GETDATE())

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following