Hi Martin,


I have encountered a problem when using Torque 3.1 with PostgreSQL, and I am trying to verify that this is an actual bug.

When using Torque 3.0, a select statement that uses a Timestamp column will be generated as something like this:

select * FROM instru_intraday
WHERE (instru_intraday.SAMPLE_DATE>{ts '2003-09-17 00:00:00.0'} AND instru_intraday.SAMPLE_DATE<{ts '2003-10-15 18:14:35.721'})


However, when using Torque 3.1, something like this is generated:

This (simplified) sql statement is generated:
SELECT * FROM instru_intraday WHERE
(instru_intraday.SAMPLE_DATE>'20030916000000' AND
instru_intraday.SAMPLE_DATE<'20030918152213')

PostgreSQL will complain about --  Bad timestamp external
representation '20030916000000'

Have you seen something like this? Thanks.

_________________________________________________________________
Concerned that messages may bounce because your Hotmail account has exceeded its 2MB storage limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to