Re: [firebird-support] There is a way to format datetime directly in SQL ?

Matthias Hanft schrieb am 17.05.2012 um 12:14 (+0200): Huan Ruan wrote: select extract(year from current_date) || '-' || lpad(extract(month from current_date), 2, '0') || '-' || extract(day from current_date) from rdb$database Is this an atomic operation? It is: It

[firebird-support] rfunc procedure does not work in Firebird 2.5

Firebird 1.5 is trying to ask the employee strcount procedure. But the Firebird 2.5 does not work. What can I do for work. - SELECT STRCOUNT( '.', '81.52.525') FROM RDB$DATABASE; error message: SQL Error: invalid request BLR at offset 60 function STRCOUNT is not

Re: [firebird-support] There is a way to format datetime directly in SQL ?

hamacker wrote: There is a way to format a datetime inside a query ? You can find some interesting ideas here, ranging from UDFs to SUBSTRING tricks: http://www.firebirdfaq.org/faq314 HTH -- Milan Babuskov == The easiest way to import XML, CSV and textual

[firebird-support] External Files Problem

I am trying to use external files but keep getting this error Access to external file C:\magusdb\dxs3.txt is denied by server administrator. I have modified firebird.conf External file paths/directories section to include ExternalFileAccess = Restrict C:\magusdb also separately tried