Forum Discussion
woodymcglathery
Oct 14, 2022Copper Contributor
Formatting a calculated field in sql
Good morning,
I cannot find how to format a calculated date field in SQL. Any assistance would be greatly appreciated.
- olafhelperBronze Contributor
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
- woodymcglatheryCopper Contributor
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.