Posted by Hugo Kornelis on 11/02/05 00:26

On 1 Nov 2005 13:38:22 -0500, triciam wrote:

(snip)
>where orderdate > ’11/1/4’
(snip)

Hi Tricia,

I'm sorry - I sent my previous reply off, and then I remembered that I
meant to include a remark about this.

The date string '11/1/4' is highly ambiguous. Depending on where in the
world you live, this could be november first 2004, january eleventh
2004, january fourth 2011, or even april first 2011. I recommend that
you use the unambiguous format yyyymmdd instead. So if you intended the
date to be interpreted as november first 2004, write
WHERE orderdate > '20041101'

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]