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

[<Bir...@t-...>]

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

Be...@gm... wrote:
> 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,
>