Subject Re: [firebird-support] The predicate where table1.timestamp1 > coalesce(table2.timestamp1, table2.timestamp2, '1.1.2006') does not work since Firebird 2.1
Author Milan Babuskov
Dimitry Sibiryakov wrote:
> PS: You can use specification "_timestamp" instead of CAST. I.e.
> coalesce(z.upd_tsc, z.create_tsc, _timestamp '1.1.2006')

Does anyone know some documentation (or website) where one can read
about other such stuff like this _timestamp shortcut? Is it part of SQL
standard?

I don't remember seeing it anywhere in IB or FB docs.

Thanks,

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com