Sites com cursos on-line

Firebird Cálculo com Data

Select

    /*diferenca de anos entre DATANASC E ADMISSAO */

    datediff(year from DATANASC to DATAADMISSAO ) ANOS_DATANASC_ADMISSAO,

    /*diferenca de dias entre a data de DATAADMISSAO e a data atual*/

    datediff(day from DATAADMISSAO to current_timestamp) DIAS,

    /*calcula horas restantes*/ 

    trunc(trunc(cast(datediff(minute from DATAADMISSAO to current_timestamp) as numeric(9,2)) / 60) - 

        (datediff(day from DATAADMISSAO to current_timestamp) * 24)) HORAS, 

Leia mais: Firebird Cálculo com Data

Procedures Firebird

CREATE PROCEDURE FU_ABS(
   WVAR DOUBLE PRECISION)
   RETURNS (
   R_ABS DOUBLE PRECISION)
   AS
   begin
   /*
   devolve o valor Absoluto de um número.
   -123,47 ou 123,47 devolve sempre 123,47
   */
   if (:wvar is not null) then begin
   if (:wvar < 0.0000) then
   r_abs = :wvar * -1;
   else
   r_abs = :wvar;
   end

suspend;
   end

===================================
   CREATE PROCEDURE FU_ALLTRIM(
   WVAR VARCHAR(8192))
   RETURNS (
   R_ALLTRIM VARCHAR(8192))

Leia mais: Procedures Firebird