Subject Re: [firebird-support] Date Format and RowCount
Author Thomas Steinmaurer
> I have two questions for you....
> 1.- How can I format a date, for example I have this: dd-mm-yyyy and I want this result yyyymmdd..... there is a function?

If you want to that at the server, for instance when concatenating
strings (including date information) inside a PSQL code module, then
either via a selectable/executable stored procedure or a self-written
UDF. There are also UDF libraries out there which do have such a
function like the rFunc library.

> 2.- How can I get the row number affected in the last Select instruction, like @@ROWCOUNT in SQL Server.

In Firebird 1.5:

There is ROW_COUNT inside a stored procedure or trigger, but that only
makes sense for a DELETE/INSERT/UPDATE statement.

If you want to check whether a record exist, then use in PSQL:


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions