You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by yong lin <sh...@gmail.com> on 2006/09/01 03:16:51 UTC

Re: [jelly] Generate value for "now" and insert it into multiple TIMESTAMP columns with jelly:sql

The java.sql.Timestamp include data and time,if you only need time use
java.sql.Time.

2006/8/30, Dion Gillard <di...@gmail.com>:
>
> Use core:new to create a new java.util.Date object and use the time of
> that to create a java.sql.Timestamp?
>
> On 8/30/06, Karr, David <da...@wamu.net> wrote:
> > I have a jelly script using jelly:sql.  It works well.  I now have to
> > add TIMESTAMP columns to a bunch of tables I'm defining in the script,
> > and I want to define a single value at the top of the script,
> > representing the current time value, and insert that in all my "insert"
> > references.
> >
> > I've defined a tag that takes a table name and a "values" attribute, and
> > inserts a new row with those values.
> >
> > This question combines both Jelly and Oracle issues, but can anyone
> > provide a hint on how to best do this?
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: commons-user-help@jakarta.apache.org
> >
> >
>
>
> --
> http://www.multitask.com.au/people/dion/
> "If you even dream of beating me you'd better wake up and apologize" -
> Muhammad Ali
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>