What is with the MySQL TIMESTAMP type, does it get changed any time the row is updated? If so, then perhaps Torque should use DATETIME instead of TIMESTAMP for the TIMESTAMP column type (on MySQL)? When I use a TIMESTAMP in Torque, I don't expect it to change unless I explicitly set it.
-james On Thu, 2002-05-16 at 13:48, Sam Joseph wrote: > John McNally wrote: > > >I use DATETIME and torque. What's the problem you are having with it? > > > > > I was under the impression that the database.dtd does not support > DATETIME as a column name > > >http://cvs.apache.org/viewcvs/jakarta-turbine-torque/src/dtd/database.dtd?rev=1.12&content-type=text/vnd.viewcvs-markup > > i.e. > > type > ( > BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT > | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | > LONGVARCHAR > | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | > LONGVARBINARY > | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY > | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR > | DOUBLE > ) "VARCHAR" > > does not include the option "DATETIME". If I want to get a DATETIME > column in MySQL I select DATE as my column type in my schema. This by > itself would seem to require a change, i.e. what if I want a DATE column > in MySQL? it seems I have to way to request it. This implies that the > DATE, TIME, TIMSTAMP, and DATETIME column types should all be supported > at the dtd level. > > Now there is no DATETIME column type in postgreSQL, so DATE just stays > as DATE. My application cannot use TIMESTAMP in MySQL meaning that I > have to change my schema in order to get it to work with postgre. I > want to be able to release a single schema that people will be able to > use to create the appropriate database tables in both MySQL and Postgre > > In order to do this I think the database dtd should be changed to > include a DATETIME option which would map onto "DATETIME" in MySQL and > "TIMESTAMP" in PostGreSQL, and the DATE /TIME column types would be > mapped onto DATE/TIME in both databases. > > I was hoping to hear about which parts of the code would require changes > to support this. > > Thanks in advance. > > CHEERS> SAM > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- [] James A. Hillyerd <[EMAIL PROTECTED]> - Java Software Engineer [] PGP 1024D/D31BC40D F87B 7906 C0DA 32E8 B8F6 DE23 FBF6 4712 D31B C40D -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
