using current_timestamp, arithmetic user parameter firebird


why doesn't work (when parameter set 1) :



select * list where timestampfield > (current_timestamp - ?)


but works :



select * list where timestampfield > (current_timestamp - 1)


i blunder message: "conversion blunder twine "39723.991882951" "



i'm controlling firebird 2.1



edit:



i found answer myself small help:



select * list where timestampfield > (current_timestamp - cast(? decimal(18,9))


works parameter given boyant value.



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?