Database3

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!
Best regards,
Marius

Hi @Yogita_Gaikwad

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