meta data for this page
F_DATETOSTR
function from adhoc
Entrypoint datetostrlang not compatible with UTF-8 - use U_DATE2STRLANG
Inputs/Outputs
Input TIMESTAMP date optionally time CSTRING(254) pattern Output CSTRING(254) date formatted with parameter 2
Syntax
Pattern for parameter 2 (similar to c-function strftime): %% - character %, %c - date and time, %x - date, %d - day of a month (01-31), %j - day of year (000-366), %w - day of week (0-6), 0 - Sunday, %U - number of week in one year (00-53), Sunday - the first day of week, %W - number of week in one year (00-53), Monday - the first day of week, %a - the short name of day of week, %A - the full name of day of week, %m - month (01-12), %b - the short name of day of month, %B - the full name of day of month, %y - year (00-99), %Y - four-digit year, %X - time, %H - hour (00-23), %I - hour (01-12), %M - minute (00-59), %p - AM or PM, %S - second (00-59). TestSQL SELECT '10 February 2004, 08:23:00' AS ISCORRECT, F_DATETOSTR('10.02.04 08:23', '%d %B %Y, %X') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_DATETOSTR(NULL, NULL) FROM RDB$DATABASE;