[Squirrel-sql-users] squirrel and Oracle date format problem

[B***@gmx.de]

Hello,

I have a problem changing rows in tables which contains date fields. I use
the latest version ov squirrel with an orcle 9 database.

I can change the date row direct on the oracle host using sqlplus. In this
case I use e.g. 01.01.2000 as date.

With squirrel I can't change any row with an date. If I use the format
01.01.2000 I get an squirrel error the format should be yyyy-mm-dd
hh:mm:ss.fffff. But using this format I get an oracle exception.

Has somebody a solution for this?

I think this was already reported as bug.

txs,

[Gerd Wagner]

Hi,

there is a standard JDBC escape syntax for dates that any database/JDBC
driver should accept. For details see

http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec/jdbc-spec.frame11.html

The SQL Entry Area Enhancements Plugin overs an 'Escape date' entry in
the right mouse click menu of the SQL editor that will generate the
escape syntax for you. See

http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=64864&release_id=233971


Gerd

Post by B***@gmx.de
Hello,
I have a problem changing rows in tables which contains date fields. I use
the latest version ov squirrel with an orcle 9 database.
I can change the date row direct on the oracle host using sqlplus. In this
case I use e.g. 01.01.2000 as date.
With squirrel I can't change any row with an date. If I use the format
01.01.2000 I get an squirrel error the format should be yyyy-mm-dd
hh:mm:ss.fffff. But using this format I get an oracle exception.
Has somebody a solution for this?
I think this was already reported as bug.
txs,

[c***@internode.on.net]

<snip>

Post by B***@gmx.de
With squirrel I can't change any row with an date. If I
use the format 01.01.2000 I get an squirrel error the
format should be yyyy-mm-dd hh:mm:ss.fffff. But using this
format I get an oracle exception.

This is a known problem using SQuirreL with Oracle which we
are looking at.

Col