2012-02-19 15:25 AEST by Arthur Barrett - The audit trigger writes dates in this format, in the local date/time of the CVS Suite Server:

     "%Y-%m-%d %H:%M:%S"

There is an undocumented setting for oracle which uses to_date() to ensure the underlying database 
interprets this correctly:

     AuditToDate=0


If AuditToDate=1 then to_date() is used; otherwise it is not (the default).

A similar setting should be available for MS SQL Server, eg:

CONVERT(VARCHAR(20),"2012-2-18 22:23:00", 120)

The 120 conversion converts from yyyy-mm-dd hh:mi:ss(24h) format....

2012-02-19 15:33 AEST by Arthur Barrett - workaround: change the database date format to ymd, eg:

exec sp_addlanguage 'British', 'English',
   'January,February,March,April,May,June,July,August,September,October,
   November,December',
      'Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec',
   'Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday',
   ymd,1
   sp_configure 'default language', 1
   reconfigure with override

http://support.microsoft.com/kb/173907