thanks damien it worked just fine
sandarbh
----- Original Message -----
From: Damien O' Dowd
To: [EMAIL PROTECTED]
Sent: Tuesday, March 20, 2001 1:33 PM
Subject: Re: off topic -- urgent
Hi
You need to use the TO_DATE function and specify a time format in the mask
otherwise a default time of midnight is inserted. I hope this helps.
insert into date1 values(TO_DATE('17-mar-2001 12:34:01', mm-dd-yyyy
hh24:mm;ss))
>From: sandarbh
>Reply-To: A mailing list about Java Server Pages specification and
reference
>To: [EMAIL PROTECTED]
>Subject: off topic -- urgent
>Date: Tue, 20 Mar 2001 12:59:16 -0000
>
>hi all,
>please tell what will be the format of string to be inserted into oracle so
>that time is also stored
>
>example 17-mar-2001 12:34:01
>
>insert into date1 values('>above information>')
>
>sandarbh
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set
JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
