datetime now in sql server code example

Example 1: sql datetime now

SELECT GETDATE();

Example 2: ms sql now

select getdate();