Date with Z appended causes SQL Server to complain
- From: "McGeeky" <anon@xxxxxxxx>
- Date: Mon, 9 May 2005 12:18:36 +0100
SQL Server doesn't seem to be able to convert xml dates in to a datetime. I
am sending an xml message to SQL Server to instruct it to call a stored
procedure. One of the parameters is a date. The date is set to 2005-10-10Z.
This is a valid xml date but SQL Server complains about it with this
message:
Details "HRESULT="0x80040e07" Description="Error converting data type
nvarchar to datetime."
Without the Z at the end it works fine. Is there a way to get SQL Server to
parse a date in that format?
--
McGeeky
http://mcgeeky.blogspot.com
.
- Follow-Ups:
- Re: Date with Z appended causes SQL Server to complain
- From: Michael Rys [MSFT]
- Re: Date with Z appended causes SQL Server to complain
- Prev by Date: Re: For XML Problem with IIS6 and W2k3
- Next by Date: queueing xml output to msmq
- Previous by thread: Re: For XML Problem with IIS6 and W2k3
- Next by thread: Re: Date with Z appended causes SQL Server to complain
- Index(es):
Relevant Pages
|
