Thanks for the info all.<BR><BR>For my current need, a trimmed format did the trick but I'll keep in mind datepart and datename.

SQL Server 2019 supports non-XML format files and XML format files for bulk exporting and importing. Find out about non-XML format files and their benefits. You can create a non-XML format file ...

To format the output of the FOR JSON clause automatically based on the structure of the SELECT statement, specify the AUTO option. When you specify the AUTO option, the format of the JSON output is ...

Arthur Fuller responds to a reader who sent him a question recently asking how to display currency amounts in currency format. Check out the solution he offers for the reader's problem.

How an old Drawbridge helped Microsoft bring SQL Server to Linux There are certainly risks involved, but a clever research project makes it all possible.

Many customers choose to run their Microsoft SQL Server workloads on Amazon RDS for SQL Server to take advantage of its fully-managed services, high performance, and straight forward homogeneous ...