DateTime Fields in SQL Server

How to extract date part from DateTime fields in SQL Server?
SELECT convert(varchar,getdate(),101)


How To Extract Time Part Alone From DateTime Field in Sql Server?
SELECT convert(varchar,getdate(),108)


Thanks to : TechDreams

No comments: