Thanx Vadim! Vadim Gritsenko wrote:
>>From: yuryx [mailto:[EMAIL PROTECTED]] >> >>Hi all! >> >>Is there any way to insert full datetime value into oracle database >>using the following syntax: >> >><xsp:logic> >> java.util.Date today=new java.util.Date(); >></xsp:logic> >>... >> <esql:query>insert into query_stack >>(t_stamp,username,q_body,q_type) values ( >> <esql:parameter type="Date" >> >><xsp:expr>java.sql.Date(today.getTime())</xsp:expr></esql:parameter>, >> >> > >Yury, > >Please read javadoc on java.sql.Date: it is *just* date, no time inside. > >You should be using java.sql.Timestamp. > >Vadim > > > > ><esql:parameter><xsp:expr>uname</xsp:expr></esql:parameter>, > > ><esql:parameter><xsp:expr>param</xsp:expr></esql:parameter>, > > >> >> ><esql:parameter><xsp:expr>Integer.parseInt(sql_type)</xsp:expr></esql:pa >ramete > > >>r> >> ) >> >> </esql:query> >> >>I always get the result value with 'zero' time :( , and I need to be >>able to insert hh24:mi:ss values. >> >>Thanx. >>Yury. >> >> > > >--------------------------------------------------------------------- >Please check that your question has not already been answered in the >FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > >To unsubscribe, e-mail: <[EMAIL PROTECTED]> >For additional commands, e-mail: <[EMAIL PROTECTED]> > > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
