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
Hello @Yogita_Gaikwad ,
Please check this post:
Hope it helps!
Try this query
SELECT CONVERT(nvarchar(10), GETDATE("[Your date column header in]"), 101)
You can also look into this link