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

Thulasiram pakala

7y3.9k

i want convert date in Convert Date time formate yyyy-mm-dd to MM/yyyy formate

anu body can send code

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
try this code:
SELECT CONVERT(char(10), GetDate(),126)
Jignesh Kumar7y ago
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
Sivakumar Koneti7y ago
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
Priyanka Singh7y ago
Date Format SQL Statement Sample Output
MM.YYYY SELECT RIGHT(CONVERT(VARCHAR(10), SYSDATETIME(), 105), 7) AS [MM-YYYY] 06-2019
Salman Beg7y ago
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.