FORMAT function in SQL Server
FORMAT(value, format [, culture])
value: The value (date, numeric, etc.) you want to format.
format: A .NET format string that defines the output format.
culture (optional): A culture or locale identifier (like 'en-US' or 'fr-FR')
to apply culture-specific formatting.
select getdate() , FORMAT(getdate(),'MM/dd/yyyy'),FORMAT(getdate(),'MMMM'),
FORMAT(getdate(),'dd/MM/yyyy'),FORMAT(getdate(),'MM-yyyy')
select FORMAT (100000,'C','en-US')
On this page of the site you can watch the video online FORMAT function in SQL Server with a duration of hours minute second in good quality, which was uploaded by the user Sql Is Easy 01 January 1970, share the link with friends and acquaintances, this video has already been watched 53 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
