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/f0783bcfef7419e10000000a114084/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]
