I have the following query.
How can I change date notation from MM-DD-YYYY to DD-MM-YYYY?
And showing Amount column in 1,00 (comma notation instead of point 1.00).
SELECT
Invoicedate
,Invoicenumber
,CreditInvoiceNumber
,CreditInvoiceDate
,Ordernumber
,Customernumber
,Amount
,Discount
,Ordernumber
FROM CTE
ORDER BY Customernumber,Invoicedate DESC ,ProductInfo
What is the column data type for the date columns? If the data type is one of the date/time data types - then changing the display in SSMS is a matter of changing your workstations regional settings.
As for the dollar amounts - I believe those can also be adjusted based on regional settings.
If the goal is for exporting the data, then you could use CAST/CONVERT and shudder FORMAT (which is a performance killer so not recommended to use unless absolutely necessary).