now sql server code example

Example 1: ms sql now

select getdate();

Example 2: sql now

select now();