Hello Vishaal, there is no such thing like a custom date format that applies globally for all statements in SAP DB. Possibly, you may want to use Oracle SQL mode and the TO_CHAR/TO_DATE functions for your client application.
It depends largely on the interfaces you are using what's the best way to work with dates and times. But anyway, even Oracle does not know dd-MMM-yy, possibly you meant dd-mm-yy or dd-mon-yy ..., 'MMM' isn't a valid format specifier. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Vishal Kant [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2003 12:24 PM > To: Ulrich St�rk > Cc: [EMAIL PROTECTED] > Subject: RE: date format in SAP DB > > > Hi Saw the Date formats it contains only 5 date formats > EUR,ISO,INTERNAL,JIS , USA . I require the date format in dd-MMM-yy. > So Can define a custom date format in SAP DB. > > Oracle supports dd-mmm-yy :) > > Vishaal Kant > Kale Consultants Ltd. > Enterprise Software Solutions > Telephone +91 22 28259580 Ext. 322 > http://www.kaleconsultants.com > > > -----Original Message----- > From: Ulrich St�rk [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2003 3:01 PM > To: [EMAIL PROTECTED] > Subject: RE: date format in SAP DB > > > The date format is set with the DATE_TIME_FORMAT variable. > Have a look here: > http://www.sapdb.org/7.4/htmhelp/92/f0783bcfef7419e10000000a11 > 4084/content.htm > You will find information on the DATE_TIME_FORMAT parameter > there (under special paramaters) and on how to change database > parameters. > > Ulrich St�rk > > > -----Original Message----- > > From: Vishal Kant [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 12, 2003 10:09 AM > > To: [EMAIL PROTECTED] > > Subject: date format in SAP DB > > > > > > Hi, > > > > I have date format set in Oracle as "dd-MON-YY". I want > > to to set the same date format in SAP DB. How can I change > > the date format ? Is there any file where we can change the > > date format or is there any setting which I can do . Like in > > Oracle the Date format can be set in init.ora. > > > > regards > > > > Vishaal > > > > Disclaimer: > > This e-mail may contain Privileged/Confidential information and is > > intended only for the individual(s) named. Please notify the > > sender, if > > you have received this e-mail by mistake and delete it from > > your system. > > Information in this message that do not relate to the > > official business of > > the company shall be understood as neither given nor > endorsed by it. > > E-mail transmission cannot be guaranteed to be secure or > > error-free. The > > sender does not accept liability for any errors or omissions in the > > contents of this message which arise as a result of e-mail > > transmission. > > If verification is required please request a hard-copy version. > > Visit us at www.kaleconsultants.com > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Disclaimer: This e-mail may contain Privileged/Confidential information and is intended only for the individual(s) named. Please notify the sender, if you have received this e-mail by mistake and delete it from your system. Information in this message that do not relate to the official business of the company shall be understood as neither given nor endorsed by it. E-mail transmission cannot be guaranteed to be secure or error-free. The sender does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. Visit us at www.kaleconsultants.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
