Microsoft KB Archive/273729

= Supported Date/Time Format for Data Warehouse =

Article ID: 273729

Article Last Modified on 7/26/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q273729



SUMMARY
In Commerce Server 2000, the Data Warehouse supports only the following format for the Date/Time field:

YYYYMMDD hhmmss



MORE INFORMATION
When you execute a query that contains a Date/Time field against the Data Warehouse database in Commerce Server 2000, you must use the &quot;YYYYMMDD hhmmss&quot; format for the Date/Time field information. For example: SELECT * FROM Address WHERE DateCreated = {ts'YYYY-MM-DD hh:mm:ss'}

Additional query words: date and time

Keywords: kbinfo KB273729

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.