lee.hopkins (7/31/2014)
I have an vb6 (dont snicker) application that is used all over the world.some users refuse to leave the regional setting to english and i am haveing an issue.
a date of '01-okt-2014' is being passed and sql has a hissy fit.
or (01-mai-2014 or 01-des-2014) is there a way to convert this to a REAL date time so i dont get
conversion failed when converting date and/or time from char string
Something like
DECLARE @DATE_STR VARCHAR(20) = CONVERT(DATE,REPLACE(REPLACE(REPLACE('01-DES-2014','s','c'),'y','i'),'K','C'),113);SELECT @DATE_STR;
😎