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])