Elke, Do you mean to say that SQL Studio will only accept dates in one format, required by ODBC? I was able to insert dates with the format 'YYYY-MM-DD'. Is this the only format it will accept? If not, what command would allow insert in the USA format? (Sorry, I've read the manuals on this, but I don't understand it well enough.)
Thank you, Ben -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Zabach, Elke Sent: Thursday, May 30, 2002 2:05 AM To: 'Ann Woo'; [EMAIL PROTECTED] Subject: RE: Ask for date format 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
<<attachment: winmail.dat>>
