FIX: BizTalk Server Adds Support for Custom Time Format Including Tenths and Hundredths (297632)

SYMPTOMS

When you create file specifications in the BizTalk Editor, you cannot create fields with a custom time format that includes decimal notation for seconds. For example, it may be desirable to have a time field that represents 03:40:23.43.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft BizTalk Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

299664 INFO: How to Obtain the Latest BizTalk Server 2000 Service Pack

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft BizTalk Server 2000 Service Pack 1.

MORE INFORMATION

Two new time formats are available with the application of BizTalk Server Service Pack 1:

HHMMSSDD
HHMMSSsss

"HHMMSSsss" is actually represented by three different formats for "s," "ss," and "sss").

The "HHMMSSDD" format is used specifically for Electronic Data Interchange (EDI) formats, which parse and validate data differently than non-EDI implementations. The formats that utilize "s" for the tenths, hundredths, and thousandths of a second exist for more detailed time notation.

NOTE: Data that is represented by fields that use the "HHMMSSs" format is treated as strings and not true date data.