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
