Hello,
I have'nt found a Statement in the Reference for setting the DateTime-Format
for a Session. If I'm working with the dbmcli-Tool , the DateTime-Format is
set to INTERNAL. If I'm working with the SQL-Studio, the DateTime-Format is
set to ISO. The corresponding Parameter of the Database is set to
INTERNAL (see below).
> dbmcli -d GSI_SAPDB -u dbm,dbm param_getfull DATE_TIME_FORMAT
OK
c18
INTERNAL
INTERNAL
CHANGE YES
INTERN NO
MANDATORY YES
CLEAR NO
DYNAMIC NO
CASESENSITIVE NO
OVERRIDE HIGHER
DEVSPACE NO
MODIFY YES
GROUP EXTENDED
DISPLAYNAME
VALUESET
MAX
MIN
INSTANCES
LASTKNOWNGOOD INTERNAL
HELP
Default format of date and time values ('INTERNAL','ISO','EUR','JIS', or
'USA')
EXPLAIN
Alterable default format of date, time and timestamp values
date format time format
timestamp format
__________________________________________________
'INTERNAL' YYYYMMDD HHHHMMSS YYYYMMDDHHMMSSMMMMMM
'ISO' YYYY-MM-DD HH:MM:SS YYYY-MM-DD
HH:MM:SS.MMMMMM
'EUR' DD.MM.YYYY HH.MM.SS
YYYY-MM-DD-HH.MM.SS.MMMMMM
'JIS' YYYY-MM-DD HH:MM:SS
YYYY-MM-DD-HH.MM.SS.MMMMMM
'USA' MM/DD/YYYY HH:MM AM
YYYY-MM-DD-HH.MM.SS.MMMMMM
Thanks for Help
Ingo Herrmann
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
