Formatting a calculated field in sql

New Contributor

Good morning,

 

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

2 Replies

@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

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