Microsoft Access Blog

Access DateValue() function to SQL Server equivalent

0 Shares

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

Search for:

IS NULL: Understanding and Using the Null Value in Microsoft Access
Pivoting a dynamic set
Use TryGet pattern for transient values
Normalize all constraints’ & indices’ names
“Too Few Parameters” error fix
Use properties instead of constant or magic numbers
Use controls, not fields
Designing a lookup table with logic
ID vs Code
“Truthy” and “Falsy” Values
Module level variables
Prefer compile time errors over run time errors
Minimizing stateful code
Self-documenting code
#LateBind Constant
Using Custom Functions in Calculated Controls
Hardware Recommendations For Running Access
How to Migrate Data from Access to SQL Server using SSMA (SQL Server Migration Assistant)
Microsoft Access File Extensions
Fixes or workarounds for recent issues in Access
Drag & Drop and Conditional Sorting in Microsoft Access
Enable and Disable a Form Control using VBA
Hiding the Navigation Pane with VBA
How to Display a Form Automatically when your Application Opens
Creating a Make Table Query
Access UPDATE query to SQL Server
Access InStr() function to SQL Server equivalent
Access DateValue() function to SQL Server equivalent
Access CDate() function to SQL Server equivalent
Access NZ() function to SQL Server equivalent

Powered by WordPress