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 ? 3) Whats diferences have sqlmode internal and oracle ? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
