i want to create a query from the OCRD Database.
the create Date format is DD/MM/YYYY actually. is it possible to get it back in YYYYMMDD?
i tried allready the FORMAT and TO_CHAR function but it didn't work in the SQL Statemant??
Thank you and best regards
You may use Cast or Convert to do the job. Convert is the simplest way such as: Convert(varchar(8), GetDate(), 112).
If you need query result for DTW upload, better changing date format under Excel. That would be much easier.