I have no idea, I know it works on Oracle.
(*Chris*)
----- Original Message -----
From: Cezar Totth <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 19, 1999 1:53 AM
Subject: Re: How do I set the current date thru JDBC.
> 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
>
___________________________________________________________________________
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
