|
|
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)
Navigation:
[Reply to this message]
|