Error with different date format between C# and T-SQL

Question

I have problem with datetime format for C# and T-SQL.

C# application is using DD.MM.YYYY HH.mm.SS format
T-SQL is using MM\DD\YYYY HH.mm.SS format

Obviously T-SQL returns Error converting data type nvarchar to datetime. error.

Is there a way how to check and transform datetime format on SQL side? I would like T-SQL to be able to use DD.MM.YYY format.

Thanks.

T-SQL doesn't use any string formatting - a DateTime is a DateTime is a DateTime and doesn't have any formatting associated with it. You should use either parametrized queries, or if you really must have a date in string format, use the ISO-8601 standard format (YYYYMMDD or YYYYMMDDTHH:MM:SS) — marc_s
– marc_s, Commented Nov 13, 2011 at 20:57

Oded · Accepted Answer · 2011-11-13 20:55:30Z

4

Use parameterized queries to avoid this kind of issue.

When you build your SQL as a string to pass to SQL Server, you not only encounter this kind of issue, but may also be exposing yourself to SQL Injection.

With parameterized queries, you would be passing in a DateTime value and the DB library would do the right thing.

Formats don't come into play as they are only used for display.

answered Nov 13, 2011 at 20:55

Oded

501k102 gold badges900 silver badges1k bronze badges

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

2 Comments

feronovak Over a year ago

I am using parameters: sCommand.Parameters.AddWithValue("@datetime_from", DatetimeFrom);

Oded Over a year ago

@feronovak - What type is DatetimeFrom? Can you post your full code?

Collectives™ on Stack Overflow

Error with different date format between C# and T-SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related