I need to create a function that returns a date 6 months from getutc date

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » I need to create a function that returns a...

I need to create a function that returns a date 6 months from getutc date

Rate Topic

Display Mode

Topic Options

Author

Message

stevenplee

Posted Thursday, July 29, 2010 3:09 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:05 AM
Points: 57, Visits: 224

I need some ideas on how to create a function that will return a date that is always exactly six months from the current getutcdate.

Can some one please give me some ideas?

Thanks

SL

Post #961042

bteraberry

Posted Thursday, July 29, 2010 3:16 PM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, February 23, 2013 11:07 AM
Points: 1,103, Visits: 1,170

If you literally want exactly +6 months (including the hh:mm:ss) then ...

select DATEADD(mm, 6, GETUTCDATE())

Otherwise (if you just want the mm/dd/yy) then ..

select DATEADD(mm, 6, DATEADD(dd, DATEDIFF(dd, 0, GETUTCDATE()), 0))

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help

Post #961044

« Prev Topic | Next Topic »

Permissions