Re: [Hsqldb-user] to_date

[Gordon K. <gor...@cs...>]

Sorry, I've cheated.

Since my dates are correctly formated the function:

   public static String first(String first, String second) {
      return first;
   }

works fine for me as an alias of TO_DATE.

If I get some time I may yet take a crack at a proper to_date function,=20
if anyone else wants to write the method feel free.

Regards
Gordon


On Fri, 20 Dec 2002 10:18, fredt wrote:
> This would be a useful addition to the HSQLDB Library.java functions.
> The use of the format string is supported by Java date format classes
> so this should be fairly straightforward to write. Once written, the
> name of the method should be added to the list of aliases in
> Library.java. Please send the code for inclusion in the next version
> when you're done!
>
> Fred Toussi
>
> --------------------------
>
> Gordon Keith wrote:
>
> I have an application that currently works with Oracle via JDBC.
>
> I'm trying to make it work with both Oracle and hsqldb.
>
> In oracle to select on a time I use:
>   select * from underway_data where
>     local_time > to_date('2000-04-06 00:00:00','YYYY-MM-DD
> hh24:mi:ss')
>
> In hsqldb this gives me:
> java.sql.SQLException: Unexpected token: TO_DATE in statement [select
> * from underway_data where local_time > to_date('2000-04-06
> 00:00:00','YYYY-MM-DD hh24:mi:ss')]
>
> In hsqldb I use:
>   select * from underway_data where
>     local_time > '2000-04-06 00:00:00'
>
> But this in oracle gives:
> ORA-01861: literal does not match format string
>
> I'd rather not have to test for the connection type when performing
> queries (I already do that for DDL statements).
>
> My thought is that the easiest way around this would be to create an
> alias in my hsqldb database for to_date that points to a function
> does that job.
>
> Does this sound a reasonable approach?
> Does anyone have another solution?

--=20

Gordon Keith
Programmer/Data Analyst
Marine Acoustics
CSIRO Marine Research
http://www.marine.csiro.au

"Everything that can be invented has been invented."=20
- Charles H. Duell, commissioner of U.S. Office of Patents in 1899