About date type write error

Question

太志廣瀬 1

Client : SQL Server Native Client 11.0
Server : SQL Server 2019

Date type data cannot be written.
But datetime2 type is OK.
Why?

cheong00 3,491 Reputation points Volunteer Moderator

2021-05-13T04:00:12.673+00:00

Show your code on how you pass your date parameter. And the "date" value your variable contains.

Btw, also check this on how to pass parameter for date SqlType.
Olaf Helper 47,621 Reputation points

2021-05-14T05:53:09.277+00:00

I don't see any peace of code nor a complete error message; so please provide more informations.
CathyJi-MSFT 22,431 Reputation points Microsoft External Staff

2021-05-20T03:10:44.547+00:00

Hi @太志廣瀬 ,

Any update for this thread? Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

2 answers

cheong00 3,491 Reputation points Volunteer Moderator

2021-05-13T04:00:12.673+00:00

Show your code on how you pass your date parameter. And the "date" value your variable contains.

Btw, also check this on how to pass parameter for date SqlType.
Olaf Helper 47,621 Reputation points

2021-05-14T05:53:09.277+00:00

I don't see any peace of code nor a complete error message; so please provide more informations.
CathyJi-MSFT 22,431 Reputation points Microsoft External Staff

2021-05-20T03:10:44.547+00:00

Hi @太志廣瀬 ,

Any update for this thread? Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Answer 1

太志廣瀬 1

Sorry, my information was wrong.

Client ODBC System DSN driver : SQL Server
Server : SQL Server 2019.

Olaf Helper 47,621 Reputation points

2021-05-14T06:19:31.98+00:00

Still to less on informations, so please provide more details.
CathyJi-MSFT 22,431 Reputation points Microsoft External Staff

2021-05-14T06:59:22.35+00:00

Hi @太志廣瀬 ,

Please provide the information that we mentioned above.

Answer 2

> Date type data cannot be written.

Could you share us your script for analysis? What are the values of date that you want written?

Default string literal format for date type is YYYY-MM-DD. Such as 2021-05-13

Default string literal forma for datetime2 is YYYY-MM-DD hh:mm:ss[.fractional seconds]. Such as 2021-05-13 12:35:29.1234567

By the way, what is the error message that you got? Please also share us the error message.

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.