> 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]>
