Rainer Gierk wrote: > I have create a database Instance with parameter DATE_TIME_FORMAT EUR. > The documentation describe EUR with format dd.mm.yyyy . > > I can't insert a date with format 5.2.2002, only 2002-2-5. > > Why? Who can help?
Which client-tool do you use ? If you use SQL Studio, ODBC directly or JDBC the following sentence from the reference manual is the explanation you asked for: The ANSI date and time format is used by ODBC and JDBC applications and cannot be replaced with a different date and time format. See http://www.sapdb.org/htmhelp/e2/55683ab81fd846e10000000a11402f/frameset.htm for the explanation of the so called (ok, funny name) ANSI datetime_format. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
