Alejandro Michelin Salomon [mailto:[EMAIL PROTECTED] > Sent: Montag, 24. Februar 2003 13:22 > To: Sapdb General List > Subject: RES: Format a Date Field > > > > Elke wrote : > > -----Mensagem original----- > De: Zabach, Elke [mailto:[EMAIL PROTECTED] > Enviada em: segunda-feira, 24 de fevereiro de 2003 06:26 > Para: 'Alejandro Michelin Salomon'; Sapdb General List > Assunto: RE: Format a Date Field > > > Alejandro Michelin Salomon wrote: > > > > > How i can format a date field ? > > > > This is a query in mysql : > > > > SELECT Usuario, Passw, Nivel, Color, Nome, Imagem, Iniciales, > > DATE_FORMAT( > > Aniversario,'%d/%m/%Y') As Aniversario, > > Email, Ramal > > FROM usuarios > > WHERE IdUser = 1 > > > > The DATE_FORMAT( Aniversario,'%d/%m/%Y') funcion formats the > > field to ( > > "dd/mm/yyyy" date format ). > > > > How i can do it in sapdb ? > > >>According to > http://www.sapdb.org/htmhelp/48/0d8018b4f211d2a97100a0c9449261 /frameset.htm >>you can use the date_and_time_format USA. >>The setting has to be done according to the tool you are using. >>Then no function around your date-column is needed, but input will be expected >>in the corresponding format.
>>Or with internal-date_and_time_format and sqlmode internal you can do some substr and || >>or you can use sqlmode oracle and the function TO_CHAR (<column>, 'DD/MM/YYYY') >>Elke >>SAP Labs Berlin 1) The USA format is not valid for the most Latin American users that use DD/MM/YYYY format. ( EJ : Uruguay, Argentina, Brasil, Paraquay, Chile, etc ) 2) Hot to change de sqlmode to oracle within the sql command ? It is not possible to change the sqlmode within a sql-statement. You have to use the sqlmode at least for one statement or the whole session. How to change the sqlmode depends on the tool (for example SQLStudio) you are using 3) Whats diferences have sqlmode internal and oracle ? The reference manual describes the sqlmode internal, the real Oracle-docs version 7 describe the version we try to be compatible with, with respect to the differences between the real Oracle version and our sqlmode oracle described in http://www.sapdb.org/7.4/htmhelp/81/ee4d3c596f0b26e10000000a11402f/frameset.htm Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
