how to get current date and time in sql server without getdate function code example Example: sql server current date without time SELECT CAST (GETDATE() AS DATE)