Tim ,

> Not with the INTERVAL keyword in front of it.

OK, but then

>  select * from kalender where
>  StartTime - interval DaysBefore DAY > CURRENT_DATE

should work as well? Actually that's what I tried first.
I guess this syntax is only valid with constants, isn't it?

Uli

Roy,

<< This proves not to be the case >>

Just make sure that you put single quotes around them.  It may work for
single integer values, but it won't work for HH:MM and it isn't standard.

--
Tim Young
Elevate Software
www.elevatesoft.com

Uli,

<< should work as well? Actually that's what I tried first. I guess this
syntax is only valid with constants, isn't it? >>

You're confusing INTERVAL constants with CASTing a value to an INTERVAL.
You can't CAST a value to an INTERVAL by just putting the keyword INTERVAL
in front of it.  Just think of it like a date or time, which require the
keywords 'DATE' or 'TIME' in front of the date or time that is enclosed in
single-quotes after the keyword.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>You're confusing INTERVAL constants with CASTing a value to an INTERVAL.
>You can't CAST a value to an INTERVAL by just putting the keyword INTERVAL
>in front of it. Just think of it like a date or time, which require the
>keywords 'DATE' or 'TIME' in front of the date or time that is enclosed in
>single-quotes after the keyword.

That's a very good point and I for one have been guilty of doing just that. Intuitively it seems correct.

Roy Lambert

Tim,

> You're confusing INTERVAL constants with CASTing a value to an INTERVAL.
> You can't CAST a value to an INTERVAL by just putting the keyword INTERVAL
> in front of it.  Just think of it like a date or time, which require the
> keywords 'DATE' or 'TIME' in front of the date or time that is enclosed in
> single-quotes after the keyword.

Thank you for making that clear. The secret is disclosed.

Uli