thanks joost, i've got it ....
cheers
shan.
--- Joost Verhagen <[EMAIL PROTECTED]> wrote:
> using oracle you can use the
>
to_date(userString,'yourdateformatasusedinthedatabase')
> and then use something like
>
> select *
> from master
> where fin_date = to_date(userString,'dd-mm-yyyy')
>
> make sure your string has the correct format. If
> your datestring is no
> complete date (ie 31/1), you can use either the
> round(datestring,format)
> function or a to_char function with a
> like-statement.
>
>
> > -----Original Message-----
> > From: Shanmuga, KR [mailto:[EMAIL PROTECTED]]
> > Sent: vrijdag 11 augustus 2000 10:57
> > To: [EMAIL PROTECTED]
> > Subject: [off-topic] filter records for date
> fields
> >
> >
> > sorry for the off-topic question.
> >
> > since the ppl here are discussing abt oracle i
> thought
> > and i can get the solution ...
> >
> > i have a text field to get the date from user.
> > according to this date i need to filter and
> display
> > those records in the browser. lets say if the
> user
> > types
> >
> > 31/3
> >
> > i tried
> >
> > select * from master where fin_date like '31/3%';
> >
> > returned no records found, but sure there are
> records.
> >
> >
> > any help is appreciated.
> >
> > thanks in advance.
> >
> > cheers
> > shan.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Kick off your party with Yahoo! Invites.
> > http://invites.yahoo.com/
> >
> >
>
______________________________________________________________
> > _____________
> > 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
>
>
___________________________________________________________________________
> 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
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
___________________________________________________________________________
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
