Re: Date in a query Statement

It can not work in the date format,  how to select the data through date, following are only possible condition.

1.Give the data type of date as date in database, but u should retrive in client side as a String type.

2. store it as text in database, and make validation on date in client side.

Rasoul Hajikhani <[email protected]> wrote:
Hello,
I have the following sql statement:

SELECT code,fname,lname FROM employee WHERE datestarted = '02/12/2001'

This works fine when executed through dbaccess, but when I use JDBC to get a
ResultSet nothing is returned.
I am using JDBC.2.21.JC5, my back end eis is Informix Universal server.
Also, the query executes fine when I remove the date part:

SELECT code,fname,lname FROM employee

Can any one tell me what am I doing wrong since I am new to JDBC.

Thanks in advance.
-r

___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html




 ub kay rut budlee too khusboo ka safer dekhye ga koon<br>
zakhum phoolo kee terha mahkyee gye per dekhye ga koon






---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html