sql server now code example

Example 1: sql datetime now

SELECT GETDATE();

Example 2: sql now

select now();