All of us know many techniques to get
, but here I found something interesting which will work without using
Take a look
CAST( FLOOR( CAST( getDate() AS FLOAT ) ) AS DATETIME )
STR( YEAR( GETDATE() ) ) + '/' +
STR( MONTH( GETDATE() ) ) + '/' +
STR( DAY( GETDATE() ) )
Reference Link: Getting Only the Date Part of a Date/Time Stamp in SQL Server
Microsoft Student Partner | CS Student | MCTS | CP MVP | Crazy Learner | Dreamer
An Indian, who loves his country, believes in freedom, He is an enthusiast Techie and crazy learner. He is passionate about Technologies and social media. He holds bachelor degree of CS in Information Technology and now pursuing Master degree in Computer Application.
He always excited and keen Interested in learning and sharing knowledge. He loves to write blog, learn new things, listen music, taking arts and Playing Games..
He keep himself on the desk of his imagination, hanging around with some inceptions.