meta data for this page
U_DATE2STRLANG
function from adhoc
Entrypoint u_date2strlang compatible with UTF-8
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
multifunctional configurable version of F_DATETOSTR Pattern for Parameter 2 in icu-Standard:
^ Symbols ^ Meaning ^ Examples ^ Examples ^
| y | year | yy yyyy or y | 96 1996 |
| Y | year of “Week of Year” | Y | 1997 |
| u | extended year | u | 4601 |
| Q | quarter | Q or QQ QQQ QQQQ | 02 Q2 2nd quarter |
| q | Stand Alone quarter | q or qq qqq qqqq | 02 Q2 2nd quarter |
| M | month in year | M or MM MMM MMMM MMMMM | 09 Sept September S |
| L | Stand Alone month in year | L or LL LLL LLLL LLLLL | 09 Sept September S |
| w | week of year | w or ww | 27 |
| W | week of month | w | 2 |
| d | day in month | d dd | 2 02 |
| D | day of year | D | 189 |
| f | day of week in month | 2 (2nd Wed in July) | |
| g | modified julian day | g | 2451334 |
| E | day of week | E, EE, or EEE EEEE EEEEE | Tues Tuesday T |
| e | local day of week (example: if Monday is 1st day, Tuesday is 2nd day) | e or ee eee eeee eeeee | 2 Tues Tuesday T |
| c | Stand Alone local day of week | e or ee eee eeee eeeee | 2 Tues Tuesday T |
| a | am/pm maker | a | pm |
| h | hour in am/pm (1~12) | h hh | 7 07 |
| H | hour in day (0~23) | H HH | 0 00 |
| k | hour in day (0~24) | k kk | 24 24 |
| K | hour in am/pm (0~11) | K KK | 0 00 |
| m | made in hour | m mm | 4 04 |
| s | second in minute | s ss | 5 05 |
| S | millisecond (rounds to count of letters) | S SS SSS SSSS | 2 24 235 2350 |
| A | milliseconds in day | A | 61201235 |
| z | Time Zone: specific non-location | z, zz, or zzz zzzz | PDT Pacific Daylight Time |
| Z | Time Zone: RFC 822 Time Zone: localized GMT | Z, ZZ, or ZZZ ZZZZ | -0800 GMT-08:00 |
| v | Time Zone: generic non-location | v vvvv | PT Pacific Time or United States (Los Angeles) |
| V | Time Zone: generic non-location | V | PT |
| VVVV | Time Zone: generic location | VVVV | United States (Los Angeles) |
| W | week in month | 2 | |
| ' | escape for text | ' | (nothing) |
| ' ' | two single quotes produce one | ' ' | ' |
Examples
| Format Pattern | Result |
|---|---|
| yyyy.MM.dd G 'at' HH:mm:ss zzz | 1996.07.10 AD at 15:08:56 PDT |
EEE, MMM d, yy | Wed, July 10, '96 |
| h:mm a | 12:08 PM |
| hh 'oclock' a, zzzz | 12 o'clock PM, Pacific Daylight Time |
| K:mm a, z | 0:00 PM, PST |
| yyyyy.MMMM.dd GGG hh:mm aaa | 01996.July.10 AD 12:08 PM |
Sprachkennzeichen: every legal 2-digit identifier closed by the top-level-domains, e.g. de for german
TestSQL
SELECT 'Tuesday, 10 February ' || F_SQM() || '04 at 2 o' || F_SQM() || 'clock and 23 minutes 17 seconds PM' AS ISCORRECT, U_DATE2STRLANG('10.02.04 14:23:17', 'EEEE, dd MMMM ' || F_DSQM() || 'yy ' || F_SQM() || 'at' || F_SQM() || ' K ' || F_SQM() || 'o' || F_DSQM() || 'clock and ' || F_SQM() || 'm' || F_SQM() || ' minutes ' || F_SQM() || 's' || F_SQM() || ' seconds ' || F_SQM() || 'a', 'en') FROM RDB$DATABASE;
SELECT 'mardi, 10 février 2004, 14:23:17' AS ISCORRECT, U_DATE2STRLANG('10.02.04 14:23:17', 'EEEE, dd MMMM yyyy, HH:mm:ss', 'fr') FROM RDB$DATABASE;
SELECT 'Dienstag, 10 Februar 2004, 14:23:17' AS ISCORRECT, U_DATE2STRLANG('10.02.04 14:23:17', 'EEEE, dd MMMM yyyy, HH:mm:ss', 'de') FROM RDB$DATABASE;
SELECT NULL AS ISCORRECT, U_DATE2STRLANG(NULL, NULL, NULL) FROM RDB$DATABASE;