Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Cannot update Salesforce Time field

We have a Salesforce field defined as a Time. When DBAmp creates the copy or generates a load table, this get's defined as a nvarchar(40). I am able to insert data to this field with no issued, using the cast to time then cast to nvarchar(40). The actual value that get's stored and displayed is converted on load time from hh:mm:ss.nnnnnnn to hh:mm:ss.mmmZ automatically. This is all fine. However, when trying to change the time, both the formats fail with error message:

Value too large max length:0 Your length: 13 (or Your length: 16 if I use the nanosecond instead of millisecond timezone format). Can you provide any guidance?
1 person has
this problem