LinkBack URL
About LinkBacksTry adding a Z to the end - SQL server demands timezones...
<dates>2005-03-03T12:04:05Z</dates>
This also suggests you are swallowing an exception somewhere, as this
should have raised an error?
Marc
This is a discussion on Date field not getting uploaded - XML SOAP ; I have an xml field with date as follows. <dates>2005-03-03</date> I tried to upload it to SQL table. My column is defined as datetime. I wrote schema as, <xsd:element name="dates" type="xsd:date"/> But after I use bulkload and execute in VB ...
Date field not getting uploaded I have an xml field with date as follows.
<dates>2005-03-03</date>
I tried to upload it to SQL table. My column is defined as datetime.
I wrote schema as,
<xsd:element name="dates" type="xsd:date"/>
But after I use bulkload and execute in VB, the SQL column has a null value.
So, I changed my xml data as,
<dates>2005-03-03T12:04:05</dates>
Even after changing this and executing I only get value in SQl column.
How do I load dates into SQL?
Regards
Meena
Re: Date field not getting uploaded Try adding a Z to the end - SQL server demands timezones...
<dates>2005-03-03T12:04:05Z</dates>
This also suggests you are swallowing an exception somewhere, as this
should have raised an error?
Marc
Re: Date field not getting uploaded I tried adding an Z at the end.
But still data is not getting loaded into SQL table.
Any help?
Regards
Meena
"Marc Gravell" <marc.gravell> wrote in message
news:uuZPTSHxHHA.3944@TK2MSFTNGP06.phx.gbl...
> Try adding a Z to the end - SQL server demands timezones...
> <dates>2005-03-03T12:04:05Z</dates>
>
> This also suggests you are swallowing an exception somewhere, as this
> should have raised an error?
>
> Marc
>
Re: Date field not getting uploaded I tried adding an Z at the end.
But still data is not getting loaded into SQL table.
Any help?
Regards
Meena
"Marc Gravell" <marc.gravell> wrote in message
news:uuZPTSHxHHA.3944@TK2MSFTNGP06.phx.gbl...
> Try adding a Z to the end - SQL server demands timezones...
> <dates>2005-03-03T12:04:05Z</dates>
>
> This also suggests you are swallowing an exception somewhere, as this
> should have raised an error?
>
> Marc
>