Christoph Gaffga wrote:
>Why you don't try this:
>
><esql:query>insert into query_stack
>(t_stamp,username,q_body,q_type) values (
> NOW(),
>
This doesn't work (with sql exception )
It worked with 'sysdate' word instead of now() statement , but I have
solve problem with use Data objects for any dates...
It worked with to_date('<xsp:expr>mytimestamp</xsp:expr>','DD-MM-YYYY
hh24:mi:ss') statement also.
Thanx for the your reply.
Yury.
> <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:parame
>ter>
> )
> </esql:query>
>
>
>yours
>Christoph Gaffga
>[EMAIL PROTECTED]
>
>
>
>From: "yuryx" <[EMAIL PROTECTED]>
>
>
>>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:parame
>ter>
>
>
>> )
>>
>> </esql:query>
>>I always get the result value with 'zero' time :( , and I need to be
>>able to insert hh24:mi:ss values.
>>
>>
>
>
>
>---------------------------------------------------------------------
>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]>
