When you create or alter the table, use DEFAULT SYSDATE something like this:
CREATE TABLE EMPLOYEES
(
ID CHARACTER VARYING(21) NOT NULL,
NAME CHARACTER VARYING NOT NULL,
CREATIONTIME DATE DEFAULT SYSDATE
);
Then you don't have to do anything in the java program, simply use a
statement like
INSERT INTO EMPLOYEES (ID, NAME) VALUES ('E15','Wilson P');
(*Chris*)
----- Original Message -----
From: Wilson. P <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 12, 1999 11:37 PM
Subject: Re: How do I set the current date thru JDBC.
> I'm using 'Prepared statement' only. But, I how to set the default date?..
>
> wilson
>
> Chris Pratt wrote:
>
> > The easiest way is to use a PreparedStatement and the setDate method.
> > (*Chris*)
> >
> > ----- Original Message -----
> > From: Wilson. P <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, July 12, 1999 9:00 PM
> > Subject: How do I set the current date thru JDBC.
> >
> > > Hi all
> > >
> > > I have setTime() function. But, I don't know how to get the current
date
> > > to set into the Oracle database.
> > >
> > > bye
> > > wilson
> > >
> > > --
> > >
> > >
> > >
> >
> >
___________________________________________________________________________
> > 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
