Is it possible to have something like this in sql:

select  current_date()-interval cast(mydays as varchar) day from mytable where mydays>0

Yusuf Zorlu
MicrotronX

Yusuf


Dunno - what happens if you try it?

Roy Lambert

Roy Lambert wrote:

<< Dunno - what happens if you try it?

with cast:
select  current_date()-interval cast(mydays as varchar) day from mytable where mydays>0

ElevateDB Error #700 An error was found in the statement at line 1 and column 33 (Expected interval constant but instead found cast)


without cast:
select  current_date()-interval mydays day from mytable where mydays>0

ElevateDB Error #700 An error was found in the statement at line 1 and column 33 (Expected interval constant but instead found mydays)


So it seems that the parameter for interval can't be another field. Any tricks to get this work?

Yusuf Zorlu
MicrotronX

Yusuf ,

What type is "mydays" ?

--
Fernando Dias
[Team Elevate]

Yusuf

I'm guessing from part of the statement that mydays is integer in which case

select current_Date - cast(mydays as interval day)  from mytable

should work. Wether it gives you what you want is something else though.

Roy Lambert

Roy Lambert wrote:

<< select current_Date - cast(mydays as interval day)  from mytable

<< should work. Wether it gives you what you want is something else though.

Thank you very much Roy, that query is working.
Sometimes we don't see the forest because of too much trees...
Yusuf Zorlu
MicrotronX