This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
Monday, February 14, 2022
2 Digit Year in SQL Server
FORMAT(DATEADD(year, 1, getdate()), 'yy')
-- In Select statement
Select FORMAT(DATEADD(year, 0, getdate()), 'yy') from PRODDTA.F0010 where ccco='00000'
No comments:
Post a Comment