|
Home > Archive > BizTalk Server Tools > May 2004 > Schema Editor question about time data type and its format
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Schema Editor question about time data type and its format
|
|
| Linda Comstock 2004-05-20, 5:43 pm |
| I created a schema with a field defined with the data type of "xs:time" and
a format of "hhmm". When I validated a file with the time field set to
"2231", the validation failed with a message that the "string was not
recognized as a valid DateTime. Why is the value "2231" not a valid time?
This is a flat file with positional records and I checked to make sure that
the preceding fields are defined correctly.
Regards,
Linda Comstock
| |
| David Downing [MSFT] 2004-05-20, 8:37 pm |
| Try HHmm ... hh indicates a 12 hour clock.
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linda Comstock" <ecc@oh.com> wrote in message
news:eimfM3qPEHA.2128@TK2MSFTNGP11.phx.gbl...
> I created a schema with a field defined with the data type of "xs:time"
and
> a format of "hhmm". When I validated a file with the time field set to
> "2231", the validation failed with a message that the "string was not
> recognized as a valid DateTime. Why is the value "2231" not a valid time?
>
> This is a flat file with positional records and I checked to make sure
that
> the preceding fields are defined correctly.
>
> Regards,
> Linda Comstock
>
>
| |
| Linda Comstock 2004-05-21, 5:55 pm |
| David,
Thanks for the quick response. I had to manually key the 'HHmm' value into
the custom format attribute because the values in the drop down list for the
custom time formats all started with the lowercase 'hh'.
Thanks,
Linda
"David Downing [MSFT]" <ddowning@online.microsoft.com> wrote in message
news:us9D1drPEHA.808@tk2msftngp13.phx.gbl...
> Try HHmm ... hh indicates a 12 hour clock.
>
> --
> Dave
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Linda Comstock" <ecc@oh.com> wrote in message
> news:eimfM3qPEHA.2128@TK2MSFTNGP11.phx.gbl...
> and
time?[vbcol=seagreen]
> that
>
>
| |
| David Downing [MSFT] 2004-05-21, 5:55 pm |
| If I remember correctly, we used the same list as BTS2002 and BTS2000 had.
The format for the custom date/time field uses the standard .Net date/time
formatting.
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linda Comstock" <ecc@oh.com> wrote in message
news:Or0OfnzPEHA.2704@TK2MSFTNGP10.phx.gbl...
> David,
> Thanks for the quick response. I had to manually key the 'HHmm' value
into
> the custom format attribute because the values in the drop down list for
the
> custom time formats all started with the lowercase 'hh'.
>
> Thanks,
> Linda
>
> "David Downing [MSFT]" <ddowning@online.microsoft.com> wrote in message
> news:us9D1drPEHA.808@tk2msftngp13.phx.gbl...
> rights.
"xs:time"[vbcol=seagreen]
to[vbcol=seagreen]
> time?
>
>
|
|
|
|
|