This table shows the Microsoft® SQL Server™ equivalent function for each Microsoft Access function.
| Access | SQL Server |
|---|---|
| now(x) | getdate(x) |
| date(x ) | convert(datetime,convert(varchar,getdate(x))) |
| year(x) | datepart(yy,x) |
| month(x) | datepart(mm,x) |
| day(x) | datepart(dd,x) |
| weekday(x) | datepart(dw,x) |
| hour(x) | datepart(hh,x) |
| minute(x) | datepart(mi,x) |
| second(x) | datepart(ss,x) |
| datepart("<Access datepart>", x) | datepart(<SQL Server datepart>, x) |
| dateadd("<Access datepart>", x, y) | dateadd(<SQL Server datepart>, x, y) |
| datediff("<Access datepart>", x, y) | datediff(<SQL Server datepart>, x, y) |