How to convert string to Date in T-SQL?

Question

I have defined my update query as follows to update a Date column.

declare @fromDate date;
set @fromDate = '2019-04-31'

update [dbo].[sites] 
  set [FromDate]= @fromDate 
where siteid=2832

Above gives following error:

Conversion failed when converting date and/or time from character string.

What Im doing wrong here?

That is teh catch thanks alot..im trying for an hour with this silly issue — Ratha
– Ratha, Commented Jun 12, 2019 at 2:16

Raka · Accepted Answer · 2019-06-12 02:16:37Z

3

April doesn't have 31 days, if you pass invalid date you will get error. Try with some valid date like 2019-04-30

answered Jun 12, 2019 at 2:16

Raka

4272 silver badges10 bronze badges

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

Comments

someRandomSerbianGuy · Accepted Answer · 2019-06-12 01:49:34Z

0

If it will work is most likely dependent on what settings you run on your server for dates. You can use CONVERT(datetime, '2019-04-31') this will convert any string to datetime type that your server supports.

answered Jun 12, 2019 at 1:49

someRandomSerbianGuy

4915 silver badges19 bronze badges

2 Comments

Ratha Over a year ago

When I do above conversion I get this error.//The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.//

Gordon Linoff Over a year ago

@Ratha . . . If this isn't the problem, then the most likely issue is a trigger on the table. Have you looked at the triggers?

Collectives™ on Stack Overflow

How to convert string to Date in T-SQL?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related