COnvert Date time formate yyyy-mm-dd to MM/yyyy formate

Question

Hi i want convert date in Convert Date time formate yyyy-mm-dd to MM/yyyy formate anu body can send code

Priyanka Singh · Answer

Date Format SQL Statement Sample Output MM . YYYY SELECT RIGHT(CONVERT(VARCHAR(10), SYSDATETIME(), 105), 7) AS [MM-YYYY] 06-2019

Jignesh Kumar · Answer

Hi Thulasiram, Please find all type of conversion for date format in below link and for your query, SELECT RIGHT ( CONVERT ( VARCHAR (10), GETDATE(), 105), 7) AS [MM-YYYY] http://www.sql-server-helper.com/tips/date-formats.aspx

Mageshwaran R · Answer

Hi, try this code: SELECT CONVERT ( char (10), GetDate(),126)

Sivakumar Koneti · Answer

SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY] example :- SELECT CONVERT(VARCHAR(10), CAST('2010-04-14' AS DATETIME), 103) AS [DD/MM/YYYY] https://stackoverflow.com/questions/9126246/date-conversion-issue-yyyy-mm-dd-to-dd-mm-yyyy

Salman Beg · Answer

Hi. You can convert to MM/dd/yyyy directly. But as you said about MM/YYYY then for that split it and concat it. Refer these links for more, http://sqlinfo.net/sqlserver/sql_server_SELECT-Formatting_Date_Time.php https://www.w3schools.com/sql/func_sqlserver_convert.asp https://www.mssqltips.com/sqlservertip/4884/sql-server-2016-stringsplit-function/ http://www.sqlservertutorial.net/sql-server-string-functions/sql-server-concat-function/ Thanks.

COnvert Date time formate yyyy-mm-dd to MM/yyyy formate

Answers (5)