RE: [PHP-WIN] inserting date into oracle!!!

THANKS!!! made my day!!! :) -----Original Message----- From: Jan Matejka [mailto:Jan.Matejka@koncept.cz] Sent: quinta-feira, 21 de Fevereiro de 2002 11:56 To: 'Sandeep Murphy' Subject: RE: [PHP-WIN] inserting date into oracle!!! sql +="VALUES("+temp+","+code+","+COLAB_COD+","+RESERVED+ ",(to_date('"+dateString+"','dd/mm/yyyy')))"; MaT > -----Original Message----- > From: Sandeep Murphy [mailto:Sandeep.Murphy@oni.pt] > Sent: Thursday, February 21, 2002 10:57 AM > To: php-windows@lists.php.net > Subject: [PHP-WIN] inserting date into oracle!!! > > > Hi, > > I have been trying to insert the current date into ORACLE in vain... > > my query reads like this.. > > java.text.SimpleDateFormat formatter = new > java.text.SimpleDateFormat("dd/MM/yyyy"); > java.util.Date currentTime_1 = new java.util.Date(); > String dateString = formatter.format(currentTime_1); > > // Have to use Java.util.date.... > > out.println( "<br>" ); > out.println( dateString ); // shows current date Fine.. > > sql = "INSERT into > RESERV_DOC_UPD(CODE,DOC_COD,COLAB_COD,RESERVED,DATE_RESERV)"; > > sql += > > "VALUES("+temp+","+code+","+COLAB_COD+","+RESERVED+","+(to_dat > e(dateString, > dd/mm/yyyy))+")"; > > Can anyone Please tell me whats wrong with this query and the > remedy for > it!!??? > > Thnx a lot in adv, > > gaucho > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >