Re: [Firebird-website] Convertin DATE_SUB(NOW(), INTERVAL nauvodni DAY)

[Lester C. <le...@ls...>]

Pepa Chmel wrote:

> ... WHERE vznik >= DATE_SUB(NOW(), INTERVAL nauvodni DAY)
>  
> Please can anybody help me to replace this  expression from MySQL to FB 
> equivalent?
>  
> I cant find usable documentation of possible functions of FB to help 
> myself alone.

First you need to try asking at
http://groups.yahoo.com/group/firebird-support

This is not a support list

WHERE vznik >= CURRENT_DATE + nauvodni

should work. You just work in days without having to do anything extra.

-- 
Lester Caine
-----------------------------
L.S.Caine Electronic Services