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:
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:
| ||||||||||||||||||||||||||||||
Thank you for your valuable feedback
ReplyDeleteI appreciate the time you spent finding that information
ReplyDeleteThanks for your feedback
Delete