![]() Hido u want below if yes ok and enjoySELECT RIGHT(CONVERT(VARCHAR(10),GETDATE(),112),6) Tariq NaeemSenior Software DeveloperComputer System IntegrationHouse # 6 Street # 1 Cavalry GroundsLahore Punjab- PakistanCell: 00448Land: 0092 42 6683483Email: Thu, 06:28:42 +0000Subject: Changinf the date format in sql server like YYMMDD I am using SELECT CONVERT(VARCHAR(10),GETDATE(),112) it is giving 20080403 but i want result in YYMMDD format. ![]() Hido u want below if yes ok and enjoySELECT RIGHT(CONVERT(VARCHAR(10),GETDATE(),112),6) Tariq NaeemSenior Software DeveloperComputer System IntegrationHouse # 6 Street # 1 Cavalry GroundsLahore Punjab- PakistanCell: 00448Land: 0092 42 6683483Email: RE: Changinf the date format in sql server like YYMMDDDate: Thu, 07:49:46 +0000
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |