| http://www.w3.org/ns/prov#value | - The data is a text file, and the date/time fields are in a numerical, integer format (UNIX EPOH format): 1251781074Cisco told me to convert that to a readable DATETIME format with this formula:myfield = DATEADD(hour,-5,(dateadd(second ,myfield, '1/1/1970')))This works correctly, but since the data is stored as an INT field, I cannot put a clause on my results.
|
