db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: overriding date format
Date Mon, 29 May 2006 08:22:17 GMT
This is strange, in the test project dates are read and written and it
works allright for mysql.

If you want to change Torque's handling of dates, look at the mysql adapter
class, DBMM, from the runtime. There, a method getDateString() is called to
get a String out of a Date.

         Thomas

"Steve Vanspall" <svanspall@madman.com.au> schrieb am 29.05.2006 04:55:16:

> HI I have this odd problem where Torque attempts to create SQL with just
> a raw toString() value of a date object.
>
>
>
> This doesn't return any results in MySQL, oddly it doesn't throw an
> error either.
>
>
>
> If I put the same dates into my SQL statement, as a properly formatted
> string i.e. 'YYYY-MM-DD HH:MM:SS' (rather than YYYYMMDDHHMMSS, which is
> what Torque is doing) the correct results are returned.
>
>
>
> Is there a way to override how torque formats dates when creating SQL
> query strings?
>
>
>
> I am trying to avoid having to go through and find all the points where
> dates are set in my application.
>
>
>
> Any help would be great
>
>
>
> Regards
>
>
>
> Steve
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message