SQLCMD -S ChangeToServerName -d ChangeToDatabaseName -E -Q "select * from [CustomerInvoices] where convert(date,invoicedate)=convert(date,getdate())" -s "," -o "D:\Result\Excel Export\DailySales.csv"
Microsoft Help
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15