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>,
<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:parameter>
)
</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]>
