Hi,
I need to know, is this example standard SQL or is it Oracle specific.
(e.g. "SYSDATE" function ?)
Thanks,
Cezar.
On Mon, 12 Jul 1999, Chris Pratt wrote:
> 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
>
___________________________________________________________________________
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
