Hi ! Standart JDBC Date (java.sql.Date) format : "yyy-mm-dd".
----- Original Message ----- From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: "Shah, Chintan V (Chintan)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 23, 2001 9:43 AM Subject: RE: Urgent : Problems with JDBC Date formats... > In that case perhaps you could try using the SQL TO_DATE function. I'm > not sure what the proper syntax for this is, but in Oracle you could use > something like: > > "Select * From <table> WHERE (<dateField> = TO_DATE('2001/01/01', > 'yyyy/mm/dd'))" > > failing that, see if you can change the default date format in the > database. > > hth > dim > > > > On Tue, 23 Oct 2001, Shah, Chintan V (Chintan) wrote: > > > Thanks for the guidance, but the problem is...my whole application is > > ready...i'm not using PreparedStatement anywhere... (to be honest, i've > > never used also...). And my SQL Statements are built dynamically in my Java > > Beans depending on the input coming from the users. So, I would prefer a > > solution, which doesn't force me to make drastic changes in my code... > > > > thanks and regards, > > Chintan > > > > -----Original Message----- > > From: Dmitri Colebatch [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 23, 2001 11:11 AM > > To: '[EMAIL PROTECTED]' > > Subject: Re: Urgent : Problems with JDBC Date formats... > > > > > > I cant guarentee that this will work with Access and SQL server, but the > > proper way to do what you're trying to do is use a PreparedStatement with > > setDate(2, new Date(2001, 1, 1)). > > > > hth > > dim > > > > On Tue, 23 Oct 2001, Shah, Chintan V (Chintan) wrote: > > > > > Hi all, > > > > > > This is a very off-topic post (as perhaps it has nothing to do with > > tomcat), > > > but I hope people would like to guide me on this.. > > > > > > I'm using Tomcat 3.2, Apache 1.3.19, Jdk 1.3, Jdbc-Odbc Driver on Win NT > > > 4.0. I want my application to work with both the databases..i.e. with > > > Ms-Access 2000 and SQL Server 7.0. > > > > > > I completed my whole application with Ms-Access, everything working > > > fine..then I tried with SQL Server 7.0...by exporting databases from > > > Ms-Access to SQL Server. For most of the parts of my code...which is > > > interacting with DBs thru JDBC worked fine...except for some syntactical > > > changes... but the major problem is with field types of *DATE*. > > > In Ms-Access, the field type is "Date/Time - short date" and in SQL server > > > it is "smalldatetime". > > > > > > E.g. SQL Stmt : "Select * From <table> WHERE (<dateField> = #2001/01/01#)" > > > gives desired results in MS-Access, but when the DB is SQL Server, it > > gives > > > error. > > > > > > And the same way, SQL Stmt : "Select * From <table> WHERE (<dateField> = > > > '2001/01/01')" gives desired results in SQL Server, but when the DB is > > > Ms-Access, it gives syntax error, saying that data types mismatch in > > > criteria expression. > > > > > > So, how should I deal with these types of things in my code, to make it > > > compatible with Ms-Access and SQL Server as well. > > > > > > Your guidance will be a great help for me. > > > > > > thanks and regards, > > > Chintan. > > > > >