GETDATE() in local language

DECLARE @date DATETIME = GETDATE()

SELECT
 FORMAT( @date,'dddd, MMMM dd, yyyy hh:mm:ss tt','en-US')
   AS 'US',
 FORMAT( @date,'dddd, MMMM dd, yyyy hh:mm:ss tt','hi-IN')
   AS 'Hindi',
 FORMAT( @date,'dddd, MMMM dd, yyyy hh:mm:ss tt','kn-IN')
  AS 'Kannada',
  FORMAT( @date,'dddd, MMMM dd, yyyy hh:mm:ss tt','te-IN')
  AS 'Telugu',
    FORMAT( @date,'dddd, MMMM dd, yyyy hh:mm:ss tt','ta-IN')
  AS 'Tamil',
    FORMAT( @date,'dddd, MMMM dd, yyyy hh:mm:ss tt','or-IN')
  AS 'Odia',
    FORMAT( @date,'dddd, MMMM dd, yyyy hh:mm:ss tt','ml-IN')
  AS 'Malayalam',
    FORMAT( @date,'dddd, MMMM dd, yyyy hh:mm:ss tt','gu-IN')
  AS 'Gujarati'

Results:
US Hindi
Friday, December 13, 2019 06:06:46 PM शुक्रवार, दिसम्बर 13, 2019 06:06:46 अपराह्न
Telugu Tamil
శుక్రవారం, డిసెంబర్ 13, 2019 06:06:46 అపరాహ్న வெள்ளிக்கிழமை, டிசம்பர் 13, 2019 06:06:46 மாலை
Malayalam Gujarati
വെള്ളിയാഴ്‌ച, ഡിസംബർ 13, 2019 06:06:46 PM શુક્રવાર, ડિસેમ્બર 13, 2019 06:06:46 ઉત્તર મધ્યાહ્ન
Kannada Odia
ಶುಕ್ರವಾರ, ಡಿಸೆಂಬರ್ 13, 2019 06:06:46 ಅಪರಾಹ್ನ ଶୁକ୍ରବାର, ଡିସେମ୍ବର 13, 2019 06:06:46 PM

Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS