07-31-2023, 09:57 AM
Try this:
Portuguese
SELECT format(dateadd(month, 0, getdate()), 'MMMM', 'pt-pt') + ' ' + convert(varchar(10),year(getdate()),100)
Result:
maio 2019
----------
English
SELECT format(dateadd(month, 0, getdate()), 'MMMM', 'en-US') + ' ' + convert(varchar(10),year(getdate()),100)
Result:
May 2019
If you want in another language, change '**pt-pt**' or '**en-US**' to any of these in [link][1]
[1]:
Portuguese
SELECT format(dateadd(month, 0, getdate()), 'MMMM', 'pt-pt') + ' ' + convert(varchar(10),year(getdate()),100)
Result:
maio 2019
----------
English
SELECT format(dateadd(month, 0, getdate()), 'MMMM', 'en-US') + ' ' + convert(varchar(10),year(getdate()),100)
Result:
May 2019
If you want in another language, change '**pt-pt**' or '**en-US**' to any of these in [link][1]
[1]:
[To see links please register here]