Sybase's highest date precision is milliseconds.
> -----Original Message-----
> From: John McNally [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 23, 2001 11:58 AM
> To: Turbine
> Subject: Re: [PATCH]timestamp- TypeMap.java, BasePeer.java
>
>
> Jon has fixed Village so that the conversion from Timestamp
> to util.Date
> only results in the loss of precision for 10^-4 seconds. I am
> interested in hearing the actual precision supported by some of the
> databases in use. Does Postgres, MySQL, Oracle, etc. have precision
> higher than milliseconds?
>
> John McNally
>
> [EMAIL PROTECTED] wrote:
> >
> > Sorry for the late: I send you the patch for the mapping of
> > TIMESTAMP type into java.sql.Timestamp (and not java.util.Date).
> > It is also necessary to introduce in the templates of
> torque the following
> > line:
> >
> > import java.sql.Timestamp;
> >
> > I think that the usage of java.util.Date produce a losing
> of information
> > that I
> > experimented in my project.
> > I solved my problems by mapping TIMESTAMP into java.sql.Timestamp.
> >
> > Michela
> >
> > PATCH FOR TypeMap.java
> >
> > --- TypeMap.java.old Thu Feb 22 16:03:58 2001
> > +++ TypeMap.java Thu Feb 22 16:13:06 2001
> > @@ -66,7 +66,9 @@
> > //
> > //import java.sql.Date;
> > //import java.sql.Time;
> > -//import java.sql.Timestamp;
> > +
> > +import java.sql.Timestamp;
> > +import java.lang.System;
> >
> > /**
> > * A class that maps JDBC types to their corresponding
> > @@ -98,7 +100,7 @@
> > * LONGVARBINARY | byte[] | ?
> > * DATE | java.sql.Date | java.util.Date
> > * TIME | java.sql.Time | java.util.Date
> > - * TIMESTAMP | java.sql.Timestamp | java.util.Date
> > + * TIMESTAMP | java.sql.Timestamp | java.sql.Timestamp
> > *
> > * -------------------------------------------------------
> > * A couple variations have been introduced to cover cases
> > @@ -160,7 +162,7 @@
> > public static final String BLOB_OBJECT_TYPE = "new
> Object()"; //?
> > public static final String DATE_OBJECT_TYPE = "new Date()";
> > public static final String TIME_OBJECT_TYPE = "new Date()";
> > - public static final String TIMESTAMP_OBJECT_TYPE =
> "new Date()";
> > + public static final String TIMESTAMP_OBJECT_TYPE = "new
> > Timestamp(System.currentTimeMillis())";
> > public static final String BOOLEANCHAR_OBJECT_TYPE =
> "new String()";
> > public static final String BOOLEANINT_OBJECT_TYPE =
> "new Integer(0)";
> >
> > @@ -184,7 +186,7 @@
> > public static final String BLOB_NATIVE_TYPE = "byte[]";
> > public static final String DATE_NATIVE_TYPE = "Date";
> > public static final String TIME_NATIVE_TYPE = "Date";
> > - public static final String TIMESTAMP_NATIVE_TYPE = "Date";
> > + public static final String TIMESTAMP_NATIVE_TYPE = "Timestamp";
> > public static final String BOOLEANCHAR_NATIVE_TYPE = "boolean";
> > public static final String BOOLEANINT_NATIVE_TYPE = "boolean";
> >
> > @@ -208,7 +210,7 @@
> > public static final String BLOB_VILLAGE_METHOD = "asBytes()";
> > public static final String DATE_VILLAGE_METHOD = "asDate()";
> > public static final String TIME_VILLAGE_METHOD = "asDate()";
> > - public static final String TIMESTAMP_VILLAGE_METHOD =
> "asDate()";
> > + public static final String TIMESTAMP_VILLAGE_METHOD =
> "asTimestamp()";
> > public static final String BOOLEANCHAR_VILLAGE_METHOD
> = "asString()";
> > public static final String BOOLEANINT_VILLAGE_METHOD =
> "asInt()";
> >
> > @@ -230,7 +232,7 @@
> > public static final String LONGVARBINARY_PP_METHOD =
> > "getBytes(ppKey)";
> > public static final String DATE_PP_METHOD = "getDate(ppKey)";
> > public static final String TIME_PP_METHOD = "getDate(ppKey)";
> > - public static final String TIMESTAMP_PP_METHOD =
> "getDate(ppKey)";
> > + public static final String TIMESTAMP_PP_METHOD =
> > "getTimestamp(ppKey)";
> > public static final String BOOLEANCHAR_PP_METHOD =
> > "getBoolean(ppKey)";
> > public static final String BOOLEANINT_PP_METHOD =
> "getBoolean(ppKey)";
> >
> > PATCH FOR BasePeer.java
> >
> > --- BasePeer.java.old Thu Feb 22 16:18:14 2001
> > +++ BasePeer.java Thu Feb 22 16:20:16 2001
> > @@ -806,6 +806,9 @@
> > else if ( obj instanceof java.util.Date)
> > rec.setValue( colMap.getColumnName(),
> > (java.util.Date)obj );
> > + else if ( obj instanceof java.sql.Timestamp)
> > + rec.setValue( colMap.getColumnName(),
> > + (java.sql.Timestamp)obj );
> > else if ( obj instanceof Float)
> > rec.setValue( colMap.getColumnName(),
> > criteria.getFloat(key) );
> >
> > ------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Search:
<http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
-----------------------------------------------------------------------
This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
