Datepart function error in sql server

Question

select case  when datepart (mm,getdate())>3 then 'abc' else 2 end

Conversion failed when converting the varchar value 'abc' to data type int.

gzaxx · Accepted Answer · 2013-07-10 11:46:57Z

5

Your values returned from case must be the same type.

select case  when datepart (mm,getdate())>3 then 'abc' else '2' end

answered Jul 10, 2013 at 11:46

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

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

Comments

Soner Gönül · Accepted Answer · 2013-07-10 11:48:03Z

2

Try this;

select CASE WHEN
       datepart (mm,getdate())>3 then 'abc' else '2'
       END

The data types of else_result_expression and any result_expression must be the same or must be an implicit conversion.

answered Jul 10, 2013 at 11:48

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

Rajeev Kumar · Accepted Answer · 2013-07-10 11:47:41Z

1

Should be like this

select case  when datepart (mm,getdate())>3 then 'abc' else '2' end

answered Jul 10, 2013 at 11:47

Rajeev Kumar

4,9739 gold badges53 silver badges91 bronze badges