meta data for this page
  •  

F_GFORMATD

function from adhoc

Entrypoint gformatd compatible with UTF-8

Inputs/Outputs

   Input     CSTRING(254)     pattern of timestamp
             TIMESTAMP        date optionally time
   Output    CSTRING(254)     date formatted like pattern from parameter 1

Syntax

   Parameter 1
           d      = day possibly one-digit
           dd    = day always in two digits
           m     = month possibly one-digit
           mm  = month always in two-digits
           yy    = year always in two digits
           yyyy = year always in four digits
           h      = hour possibly one-digit
           hh    = hour always in two digits
           n     = minute possibly one-digit
           nn   = minute always in two digits
           s     = second possibly one-digit
           ss    = second always in two digits
           all other indications will indicate according to their task in parameters 1 in the respective place.
   TestSQL
   SELECT '01-10-2005 15:09:12' AS ISCORRECT, F_GFORMATD('dd-mm-yyyy hh:nn:ss', '01.10.2005 15:09:12') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_GFORMATD(NULL, NULL) FROM RDB$DATABASE;