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 |
Post date | 2009-01-24T21:13:53Z |
Dimitry Sibiryakov wrote:
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
> PS: You can use specification "_timestamp" instead of CAST. I.e.Does anyone know some documentation (or website) where one can read
> coalesce(z.upd_tsc, z.create_tsc, _timestamp '1.1.2006')
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