mpoeschl 2002/09/19 07:33:31
Modified: src/java/org/apache/torque/adapter DBSybase.java
Log:
TRQ26 string to date conversion in MSSQL/Sybase
patch by Juarez Rudsatz <[EMAIL PROTECTED]>
Revision Changes Path
1.8 +20 -1
jakarta-turbine-torque/src/java/org/apache/torque/adapter/DBSybase.java
Index: DBSybase.java
===================================================================
RCS file:
/home/cvs/jakarta-turbine-torque/src/java/org/apache/torque/adapter/DBSybase.java,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- DBSybase.java 24 Jun 2002 18:12:19 -0000 1.7
+++ DBSybase.java 19 Sep 2002 14:33:31 -0000 1.8
@@ -57,6 +57,8 @@
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
+import java.util.Date;
+import java.text.SimpleDateFormat;
/**
* This is used to connect to a Sybase database using Sybase's
@@ -71,6 +73,9 @@
*/
public class DBSybase extends DB
{
+ /** date format */
+ private static final String DATE_FORMAT = "yyyyMMdd HH:mm:ss";
+
/**
* Empty constructor.
*/
@@ -173,5 +178,19 @@
public int getLimitStyle()
{
return DB.LIMIT_STYLE_SYBASE;
+ }
+
+ /**
+ * This method overrides the JDBC escapes used to format dates
+ * using a <code>DateFormat</code>. As of version 11, the Sybase
+ * JDBC driver does not implement JDBC 3.0 escapes.
+ *
+ * @param date the date to format
+ * @return The properly formatted date String.
+ */
+ public String getDateString(Date date)
+ {
+ char delim = getStringDelimiter();
+ return (delim + new SimpleDateFormat(DATE_FORMAT).format(date) + delim);
}
}
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
