>Does anyone know how to cast a SQL Server 2005 timestamp field value to a string and back again? I am using a FoxPro pass through query to extract data from on SQL Server system and would like to insert it into system. I would like to display the timestamp value in my FoxPro data scrub utility in a human readible format too.

Hi Scott,

The SQL Server timestamp data type is a binary value that has no meaning. It is not related to the date and time of an insert or change to data.