SqlServerKudos - Dates don’t work when copied from SQL Profiler - Error converting data type varchar to datetime

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Dates don’t work when copied from SQL Profiler - Error converting data type varchar to datetime

published 620 days, 15 hours, 53 minutes ago posted by

sa 628 days, 18 hours, 28 minutes ago

Dates don’t work when copied from SQL Profiler - Error converting data type varchar to datetime

If you are running with British english as your language or some other language with a different date format to the guys in the US then you will have come across this handy error. Msg 8114, Level 16, State 5, Procedure foo, Line 0 Error converting data...(read more)

category: News | clicked: 0 | | source: sqlblogcasts.com | show counter code

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos