JDBC and date format
Posted in 2000
Piotr Wawrzyniak — — source: Informix-list mailing list archive (1991-1998)
Hi !
I have been half day changing the values of DBDATE (to MDY4-) and GL_DATE(to
%m-%d-%Y) (both, on the client and server side)(the server and client work
on WinNT) to execute properly
select * from text where date(anydate) = '11-07-2000' --anydate is datetimecolumn
from Java using JDBC and I always get the "String to date conversion error".
When I use the string like '00/11/07' I have no error, but I must have the
string format like mm-dd-yyyy.
If somebody know what I must change to set the proper date format for JDBC
(with the sqleditor or dbaccess I have no problem) please help.
Piotrek Wawrzyniak