Thanks!

The date and tmes are being passed to a web app via a third party, so i don't have control over the format. I agree though and will take that...

Thanks - that's what I was after 🙂

OK, here's an example, this generates the following error.

SET DATEFORMAT mdy

DECLARE @Date varchar(50)

DECLARE @time varchar(50)

SET @Date = '13/01/2011'

SET @Time = '09:00:00'

select convert(datetime,@Date)+convert(datetime,@Time)

The conversion of a varchar data type to a...

Thanks for the fast reply, our local datetime format is DD/MM/YYYY, how will it know to convert 01/02/2011 to the 1st of February and not 2nd of January?