Adding 1 Month to Date Calculation Column

#1

Hi

I'm trying create a calculated column to add 1 month to a date from another column.

CREATE TABLE [dbo].[test_table_date](
[date1] [datetime] NOT NULL,
[date2] AS ([date1]+ ???)
) ON [PRIMARY]

I have tried a couple of things with no luck.Please note that I am a complete novice to TSQL. Hope someone can help.

Cheers
Cory

#2

On 2012-01-27 07:25, Cory Jones wrote:

Quote:

I'm trying create a calculated column to add 1 month to a date from another column.

CREATE TABLE [dbo].[test_table_date](
[date1] [datetime] NOT NULL,
[date2] AS ([date1]+ ???)
) ON [PRIMARY]

I have tried a couple of things with no luck.Please note that I am a complete novice to TSQL. Hope someone can help.

....AS DATEADD(MONTH, 1, [date1])

--
J.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Adding 1 Month to Date Calculation Column

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Adding 1 Month to Date Calculation Column - 01-27-2012 , 12:25 AM

Re: Adding 1 Month to Date Calculation Column - 01-27-2012 , 01:25 AM