I often have to query a large database remotely, and the Date is a crucial part.
However, the dates are expressed in Uk format, so the queries with day numbers less than 13 can be ambiguous
SaleDate >= '11/8/2005' AND
Looking at 11th August, or half of November and December?
I have often looked around for guidance on what formats can be used for date literals in SQL, but no luck so far.
Can anyone guide me to a comprehensive list, or suggest a 'universal' format (like "2005/08/11")?
Keep Up with TechRepublic