SQL question

[Ruslan Zasukhin]

On 4/22/05 1:40 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

> Hi SQL-cracks!
> 
>  
> 
> How would I do something like this:
> 
>  
> 
> "SELECT KD_ID FROM KUNDENtable WHERE OPC_ID !=0 AND changeTS > '01.01.2004
> 12:12:14'"
> 
>  
> 
> I get error 616 here and try to find timestamps newer  or older than a given
> time stamp

Strange, 616 - missing link it seems.

But you have only one table query...

> changeTS is of kTypeDateTime

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]