Posted by Spook on 03/14/07 18:42

Thank you all for your help! Plamen's idea was exactly what I needed. Celko,
We need the datetime to be accurate to verify the order times in case of
delays in dispatching.





"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1173896183.884591.226260@p15g2000hsd.googlegroups.com...
> the other thing you need to consider is adding a constraint to be sure
> that the time is always set to 00:00:00 Hrs so that you do not have
> fix it on the fly in your queries. Mop the floor but also fix the
> leak.
>

[Back to original message]