for dates and times using $ZTH and $ZDH and their opposites for going from Internal to External $ZD and $ZT.
In general SQL will be more efficient at importing data in a bulk load as it does not make use of the object instantiation
layers. SQL Defaults to external values which is why SQL is working for you
Danny Shisler wrote:
I've just downloaded a copy of Cache for evaluation purposes and have been struggling to import some legacy data in Time format. The data is in a csv file, and one of the columns is in Time format. The format is "HH:MM:SS". I've tried with no quotes, single quotes and double quotes and I always get the same type of error:
SQL -104 Field Validation failed in INSERT : Field 'StartTime' (value '06:52:59') failed validation
However if I use an insert statement with the same format e.g.:
Insert into TableName (StartTime) Values('06:52:59')
it works just fine!
I could really do with some help please.
Many thanks
Danny
