Formatting a calculated field in sql

[woodymcglathery]

Good morning,

I cannot find how to format a calculated date field in SQL. Any assistance would be greatly appreciated.

[#2]

@woodymcglathery , in common formating is done by the frontend respecting the local regional settings, not by the backend = SQL Server.

But if you want to (don't making sense) you can use the FORMAT (Transact-SQL) - SQL Server | Microsoft Learn function.

Olaf

[#3]

Good morning,

Thank you so much for the quick reply. That makes perfect sense. I just wasn't sure if it was something practiced on the backend or not; especially since I couldn't find anything on the subject. 

@woodymcglathery