Date in SQL Server

0 pts.
Tags:
Development
Hi, I want to take the curent date (month and year) and create a date as 22 nd of previous month and current year, how would I acclmplish this? For example: today is 15th Jun 2005, the result I want is: 22-MAY-2005 I would appreciate your reply. email: ravingogri@hotmail.com Thanks, Ravin L. Gogri
ASKED: June 15, 2005  12:09 PM
UPDATED: June 22, 2005  1:00 PM

Answer Wiki

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

You’ve got an interesting scenario here. Do care to elaborate?

Discuss This Question: 1  Reply

 
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
  • Vcombs
    Do you always want to go one specific date in the previous month? Is "previous month" always defined as the month before today's date or is it specific to the day of the month (i.e., if today's date is June 11th, the previous month date would be May 15th but if today's date were June 27, the previous month date would be June 15th? Just looking to clarify before offering a solution.
    0 pointsBadges:
    report

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