Get Only DateTime Part without using Convert

All of us know many techniques to get DateTime part in SQL using Convert, but here I found something interesting when I was reading an article of BenNadel [ Who he is  ]  which will work without using Convert
Take a look

 SELECT
 CAST( FLOOR( CAST( getDate() AS FLOAT ) ) AS DATETIME )
 

or

select    CAST(
    (
     STR( YEAR( GETDATE() ) ) + '/' +
     STR( MONTH( GETDATE() ) ) + '/' +
     STR( DAY( GETDATE() ) )
     )
     AS DATETIME
     )

and you can also try this one

select Dateadd(dd,0,datediff(dd,0,getdate()))

Reference Link :-  Getting Only the Date Part of a Date/Time Stamp in SQL Server

Share Knowledge
This entry was posted in SQL SERVER, TIPS/TRICKS and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *