Ann Woo wrote: > How to define yyyy/dd/mm date format in SAPDB?
As the reference manual --> basic elements --> date and time format (see http://pwww:1111/Doku/htmldoc-7.3/48/0d8018b4f211d2a97100a0c9449261/frameset .htm ) tells us, the format you want is not one of the SAP DB known formats. therefore, you cannot define it. The format USA 'MM/DD/YYYY' is known. You can set it for the whole database (installation parameter DATE_TIME_FORMAT). If you want to set it for one session, it depends on the tool/interface you are using: with ODBC (SQLStudio uses it) you will always use the format defined by ODBC. To output date values in one of the SAP DB known formats, use the function CHAR. If you want just to output the date values in the way you mentioned, then the function TO_CHAR (available with SQLMODE Oracle) or some SUBSTR and || (CONCAT) will help. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
