Skip to main content

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