TSQL DateTime formats:

Date and Time
-------------
select current_timestamp
select getdate()

Date No Time
------------
select convert( char(10), current_timestamp, 101)
select convert( char(10), getdate(), 101)