[SQL] nevermind answered my own question by looking at my question what a DOH!

select * from viwEmpIncCube where clientnum ='MSI' and Incidentdate::timestamp between '01/01/2005' and '08/18/2005 23:59' woks fine.   Joel Fradkin   Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL PROTECTED] www.wazagua.com Powere

Re: [SQL] nevermind...

John BEPPU <[EMAIL PROTECTED]> writes: > Nevermind my last post. I'm still confused, but for > different reasons. I'm on my friends box, and I have > screen running. In one tty, creating tables with the > serial type works, but in the other tty, it fails. Same comment as I was about to make fo

[SQL] nevermind...

Nevermind my last post. I'm still confused, but for different reasons. I'm on my friends box, and I have screen running. In one tty, creating tables with the serial type works, but in the other tty, it fails. Both shells are on the same box, so it must be some kind of environment issue (or that