Home/ Questions/Q 38216
Next
In Process
pratap
  • 0
Asked: 2022-04-05T05:42:35+00:00 In:

How to return only the Date from a SQL Server DateTime datatype

  • 0

How to return only the Date from a SQL Server DateTime datatype

serversql
Share

    Related Questions

    1 Answer

    1. This answer was edited. 
      SELECT CONVERT(VARCHAR(10),GETDATE(),111)

      The above statement converts your current format to YYYY/MM/DD, please refer to this link to choose your preferable format.

      • 0

    Leave an answer

    You must login to add an answer.

    Need An Account,