 |
 |
Archives of the TeradataForum
Message Posted: Wed, 29 Sep 2004 @ 22:11:33 GMT
| Subj: | | Re: Function "Monthname" in SQL Assistant |
| |
| From: | | Walter, Todd A |
If the requirement is to manage a single language for these strings (especially dates) then I recommend a review of the SDF file and the
TDLocaldef utility. This allows the specfication for the formatting specifications for most data types including the text for days of the week
(and abbrevs), months of year (and abbrevs), currency symbol, ... . These then link to the Teradata FORMAT clause which is significantly upgrade
in V2R5.0 to allow specification of all of these formatting features.
At this time this is a system wide facility - only one language can be specified for the system. This is fine if everyone wants their days in
French and their currency in Euros. It is not yet capable of being configured with multiple languages - for instance at the user/session
level.
| |
