meta data for this page
  •  

F_DATETOSTRLANG

function from adhoc

Entrypoint datetostrlang not compatible with UTF-8 - use U_DATE2STRLANG

Inputs/Outputs

   Input     TIMESTAMP        date optionally time
             CSTRING(254)     pattern
             CSTRING(2)       language identifier for the output
   Output    CSTRING(254)     date formatted with parameter 2 in chosen language

Syntax

   Language version of  F_DATETOSTR.
   Language identifier: de = German, uk = English, fr = French, es = Spanish, it =Italian, es = Spanish, pt = Portuguese,
   nl = Dutch, no = Norwegian, Bokmål, se = Swedish, dk = Danish, fi = Finnish, hu = Hungarian, ie = Irish(Gaelic),
   ee = Estonian, is = Icelandic, al = Albanian, va = Classical Latin, v1 = Ecclesiastical Latin, c1 = Catalan, s1 = Scots,
   s2 = Scottish Gaelic, w1 = Welsh, b1 = Breton, b2 = Basque, n1 = Norwegian, Nynorsk, za = Afrikaans, fo = Faroese,
   lu = Luxembourgish, w2 = Wallon
   Pattern for parameter 2 (similar to c-function strftime): sea F_DATETOSTR
   TestSQL
   SELECT 'Tuesday, 10 February 2004, 08:23:00' AS ISCORRECT, F_DATETOSTRLANG('10.02.04 08:23', '%A, %d %B %Y, %X', 'uk') FROM RDB$DATABASE;
   SELECT 'Dienstag, 10 Februar 2004, 08:23:00' AS ISCORRECT, F_DATETOSTRLANG('10.02.04 08:23', '%A, %d %B %Y, %X', 'de') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_DATETOSTRLANG(NULL, NULL, NULL) FROM RDB$DATABASE;