How to get Date Part only from Date-Time in Sql Server?

Posted by vishalneeraj-24503 on 12/26/2013 | Category: Sql Server Interview questions | Views: 3081 | Points: 40

Answer:

We can use Convert in-built sql-server function which extract Date part by passing date,so that we can get only Datepart.

For Example:-

SELECT CONVERT(DATE,GETDATE()) As 'Date_Only';

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to get Dropdown list selected Value through Ja ...

Next > : How does a For Loop start in Javascript?

More Interview Questions by vishalneeraj-24503

Latest Interview Questions