So what should I use instead? yyyy-MM-dd hh:mm:ss is the format in the db...
Tim Schraepen wrote:
My first guess would be the ":" that mark the separators between hours,
minutes and seconds.
I think they're being "misinterperated" by the connector.
On 4/13/07, acw <andreas.willadsen@gmail.com> wrote:
>
>
> When i try to fire this sql aganst Oracle
>
> jdbc://SELECT%*%20FROM%20CATS_OWNER.V_CATS_CPH_WWW_SUBSCRIBE%20WHERE%20(FLT_TYPE%20in%20('B','C','G','J','S')%20AND%20PUBLIC_ROLL_OFF%20=%200)%20AND%20SCHEDULE_TM%20>=%20'2007-04-13%2012:16:40'%20AND%20SCHEDULE_TM%20<=%20'2007-04-13%2014:16:40'
>
> i get an org.mule.umo.endpoint.MalformedEndpointException.
>
> This sql works perfectly in sql+ and TOra.
>
> The problem only comes when i add the last two conditions, SCHEDULE_TM >=
> '2007-04-13 12:16:40' AND SCHEDULE_TM <= '2007-04-13 14:16:40'
> ...SCHEDULE_TM is a Date field.
>
> What's wrong with inserting dates this way?
> --
> View this message in context:
>
http://www.nabble.com/MalformedEndpointException-tf3571684.html#a9979137> Sent from the Mule - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list please visit:
>
>
http://xircles.codehaus.org/manage_email>
>
