how to change datetime formate from 2021-05-27 to May 27 2021 12:00AM in sql
This way
DECLARE @dt DATETIME = '2021-05-27' SELECT CONVERT(VARCHAR, @dt, 100)
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.