Discussion on:

Message 29 of 44
0 Votes
+ -
Date formats
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

e.g. is
WHERE
SaleDate >= '11/8/2005' AND
SaleDate ???12/8/2005'
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")?
Posted by neal_work@...
13th Sep 2007