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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
