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 i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members