title: Converting a BMC Remedy timestamp to mm/dd/yyyy format
body: <p>According to the documentation I've found from AR Systems on BMC Remedy, timestamps in an MSSQL Server environment (we're using SQL Server 2005 here) are stored as an <strong>int</strong> datatype in UNIX timestamp format.</p>
  
  <p>I cannot for the life of me get custom SQL in Business Objects Web Intelligence to let me convert this timestamp into mm/dd/yyyy format, which I need to be able to group records by a date (without the timestamp, obviously). Anything I try to do involving math or datatype conversion throws an "invalid type" error. I can't convert the field to an int, varchar, datetime, or anything else. The only function that works is DATEADD, which still returns the full timestamp.</p>
  
  <p>How can I get this converted? I'm going nuts here!</p>