Tuesday, July 5, 2016

Access CDate() function to SQL Server equivalent


What is the SQL Server equivalent to Access CDate() function?


Access SQL
  • CDate([Event Timestamp])


SQL Server Equivalent
  • cast([Event Timestamp] as datetime)
  • convert(datetime, [Event Timestamp])

No comments: