Supported Date/Time Format for Data Warehouse (273729)

The information in this article applies to:

Microsoft Commerce Server 2000

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 "YYYYMMDD hhmmss" format for the Date/Time field information. For example:

SELECT * FROM Address WHERE DateCreated = {ts'YYYY-MM-DD hh:mm:ss'}

Modification Type:	Major	Last Reviewed:	7/26/2002
Keywords:	kbinfo KB273729