When the date is specified in ISO format (reverse date yyyy-mm-dd) SQL will interpret it correctly. It will not accept yyyy-dd-mm (day and month swapped in reverse format) as it is not a recognised format. If it is working that way, there must be some conversion going on in the application connecting to SQL, in which case it's a fault (or setting) in the client application rather than a SQL issue.