Friday, July 1, 2016

Access DateValue() function to SQL Server equivalent

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


Access SQL
  • DateValue([Event Timestamp])


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

No comments: