Dates for Languages Added with sp_addlanguage

For alternate languages added with Language Modules, the SAP ASE server sends date values to clients as datetime datatype, and the clients use localization files to display the dates in the user’s current language.

For date strings added with sp_addlanguage, use the convert function to convert the dates to character data in the server, where pubdate is datetime data and table is any table:
select convert(char, pubdate) from table

When users perform data entry on date values and need to use date names created with sp_addlanguage, the client must have these values input as character data, and sent to the server as character data.

Parent topic: sp_addlanguage