View Revisions: Issue #1550

Summary 0001550: Sybase ASE : Lost precision from Datetime fields
Revision 2014-01-30 17:57 by elong
Description On Sybase ASE, datetime fields are being synced with date and time down to seconds, but it is missing the milliseconds. The dialect is using the following function for the time portion:

convert(varchar, column, 108)

Instead, it should do the following:

right('00'+convert(varchar, datepart(HOUR,column)),2)+':'
+right('00'+convert(varchar, datepart(MINUTE,column)),2)+':'
+right('00'+convert(varchar, datepart(SECOND,column)),2)+'.'
+right('000'+convert(varchar, datepart(MILLISECOND,column)),3)

Revision 2014-01-30 13:38 by elong
Description On Sybase ASE, datetime fields are being synced with date and time down to seconds, but it is missing the milliseconds. The dialect is using the following function for the time portion:

convert(varchar, column, 108)

Instead, it should do the following:

right('00'+convert(varchar, datepart(HOUR,column)),2)+':'
+right('00'+convert(varchar, datepart(MINUTE,column)),2)+':'
+right('00'+convert(varchar, datepart(SECOND,column)),2)+'.'
+convert(varchar, datepart(MILLISECOND,column)).