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)). |