Hi, we are currently migrating from an oracle db to sqlserver. I am working through various queries in our HR System trying to amend date format.
I am trying to return dates in the DD/MM/YYYY format. This I can do for the sysdate no problem with the following:
//sYSTEM DATE dd/mm/yyyy
CONVERT(VARCHAR(10), GETDATE(), 103)
However, when I try to return the employee start date using:
//Convert EMPLOYEE.START_DATE YYYY/MM/DD
convert(date, cast (EMPLOYEE.START_DATE as varchar(8)),103)
The date comes back in the format: YYYY-MM-DD
Any ideas how I can return the date in the DD/MM/YYYY format for the above?