I thought u are making select query. For insert dont use this.
Use TimeStamp that insert in access default way.
----- Original Message -----
From: "unni" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 10, 2000 2:52 PM
Subject: Re: MS Access Question - SQL!
> 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" file://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() file://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
>
___________________________________________________________________________
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
