now() in sql server code example

Example 1: sql datetime now

SELECT GETDATE();

Example 2: ms sql now

select getdate();

Example 3: sql now

select now();