title: How to convert visit start time to a readable human date or timestamp in Big Query?
body: <p>I'm trying to convert the visit start time variable which is captured in big query to a readable date or preferably timestamp.</p>
  
  <p>I'm using standard SQL.</p>
  
  <p>I've tried using sec_to_timestamp but I believe this only works in legacy SQL within BQ.</p>
  
  <p>The google documentation talks about converting to timestamp from date expression and string expression however the visit start time is an integer.</p>
  
  <p><a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators" rel="noreferrer">https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators</a></p>
  
  <p>I've looked at the following link and tried the code in this but I get the error "function not found: integer"</p>
  
  <p><a href="https://stackoverflow.com/questions/28996419/big-query-google-analytics-time-diff-between-first-visit-and-purchase">Big Query - Google Analytics - Time diff between first visit and purchase</a></p>
  
  <p>Any other advice on dates/times captured by BQ would be greatly received.</p>
  
  <p>Thank you</p>