In databse i have column StartTime which contain date and time and i want to select only date record from StartTime column then how i do it i.e only select Date from DateTime, can u tell query for this
Try this query
SELECT CONVERT(nvarchar(10), GETDATE("[Your date column header in]"), 101)
Regards
Sudharsan
You can also look into this link
Regards
Sudharsan