title: Smarterstats API Convert DateTicks to Datetime using SQL
body: <p>I am using SmarterStats APi and one of the field in response is DateTicks and the value is in long integer 636231456000000000 
  I need to convert that to date and that should be today's date 2017-02-20
  There is no documentation and their support is not very good.</p>
  
  <p>So my question is how would a value like 636231456000000000 convert to 2017-02-20?</p>