Combining string with variable in SQL Server

Question

I am very new to SQL Server. I want to combine 01-JUL- and a variable with a year to get a date and am doing this:

select 
   *, 
   '01-Jan-1900' as from_date_x, 
   '01-JUL-' + from_finyr as to_date_x
into 
   bbt_item_6_a
from 
   bbt_item_5_finyrs

and am getting the following error:

Conversion failed when converting the varchar value '01-JUL-' to data type int.

I have tried searching for the answer but cannot get it.

Thanks

mbroshi · Accepted Answer · 2014-01-07 00:39:55Z

1

It sounds like the from_finyr field has int data type. Instead, you need:

    select *, 
        '01-Jan-1900' as from_date_x, 
        '01-JUL-' + CAST(from_finyr AS varchar(4)) as to_date_x 
    into bbt_item_6_a 
    from bbt_item_5_finyrs

answered Jan 7, 2014 at 0:39

mbroshi

9898 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AjaySingh · Accepted Answer · 2014-01-07 00:38:47Z

0

Following SQL is an example, on how you can combine "01-JUL-" and a variable with a year to get a date: SELECT CAST('01-JUL-' + @varaible AS DATE) AS to_date_x

answered Jan 7, 2014 at 0:38

AjaySingh

1215 bronze badges

Collectives™ on Stack Overflow

Combining string with variable in SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related