Thomas wrote : >>-----Mensagem original----- >>De: Koetter, Thomas Theodor [mailto:[EMAIL PROTECTED] >>Enviada em: sexta-feira, 28 de fevereiro de 2003 11:09 >>Para: 'Alejandro Michelin Salomon'; Sapdb General List >>Assunto: RE: SqlMode in ODBC Connections
>>Hi Alejandro >>> -----Original Message----- >>> From: Alejandro Michelin Salomon [mailto:[EMAIL PROTECTED] >>> Sent: Freitag, 28. Februar 2003 12:37 >>> To: Sapdb General List >>> Subject: RE: SqlMode in ODBC Connections >>[some stuff snipped] >>> >>>I.e. SQL statements like >>> >>> >>>create table mytable (tcol time) >>> >>> >>>insert into mytable set tcol = {t '12:34:56'} >>>>This works with SAP DB and ODBC. >>>>> I this ok for sapdb : >>> INSERT INTO accesslog ( Date, Time, User, Ip ) >>> VALUES ( set tcol = {t >>> '01/02/2003'},'12:34','alejandro','200.248.150.44') >>Try >>insert into accesslog values ( {d '2003-02-01'}, {t '12:34'}, 'alejandro','200.248.150.44') This work well. Hot make a select with the format dd/mm/yyyy ? For my the format for insert dates is not important, important is format date fields to say the value in the browser, when i make a select. I do not want to have to made extra work in de php code. When i want data to be displayed, i want that the database make the hard work, formating dates, numbers, geting parts of a string and many other taks. >>BTW, did you really read thoroughly what I wrote? >>Regards Thomas >>---------------------------------------------- >>Dr. Thomas K�tter >>SAP DB, SAP Labs Berlin >>SAP DB is open source. Get it! www.sapdb.org Alejandro Michelin Salomon PROBrax e-Tech, Brasil _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
