Thank you and I tried following code and it inserts the row and fails with
the same error (-3030)
>java.sql.Date date = "06/06/2000" //get the date
>String sDate = null;
>SimpleDateFormat formatter = new SimpleDateFormat ("mm/dd/yyyy");
>sDate = formatter.format(date);
At 02:17 PM 11/10/00 -0500, kavitha Ramasamy wrote:
>java.sql.Date date = getDate() //get the date
>String sDate = null;
>SimpleDateFormat formatter = new SimpleDateFormat ("mm/dd/yyyy");
>sDate = formatter.format(date);
>
>Kavitha
>
>----- Original Message -----
>From: "harjit singh" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, November 10, 2000 1:43 PM
>Subject: Re: MS Access Question - SQL!
>
>
> > You have to use a TimeStamp object
> >
> > - Harjit
> >
> > -----Original Message-----
> > From: unni [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 10, 2000 11:20 AM
> > To: [EMAIL PROTECTED]
> > Subject: MS Access Question - SQL!
> >
> >
> > Hello,
> >
> > When I am trying to insert a date into MS Access database I am getting an
> > error saying 'Data Type mismatch in criteria expression".
> > I have the column as 'small date mm/dd/yy' format and I am inserting in
>the
> > same format. Did any one have this problem before?
> >
> > Thanks.
> > -Unni
> >
> >
>___________________________________________________________________________
> > 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
> >
>
>___________________________________________________________________________
>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
