JDBC has a date 'escape' - since there is no standard way to store dates in
a database (I believe) JDBC defines an escape string that is used to send
dates to the JDBC driver, the driver then translates the escape sequence to
the approriate format for tah database - use it like this -
"INSERT into sometable VALUES(1, {d'1999-06-23'}, {d'1999-06-23'}, 'Where',
'What', 'Note')"
- where {d'YYYY-MM-DD'} is the escape sequence,
Kevin
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet API
Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Eytan Seidman
Sent: 13 July 1999 14:55
To: [EMAIL PROTECTED]
Subject: Re: How do I set the current date thru JDBC.
You need to be careful because different database request the format in
different ways. I do teh following.
Calendar currentCalendar = Calendar.getInstance();
int a = currentCalendar.get(Calendar.YEAR);
int b = currentCalendar.get(Calendar.MONTH);
b++; //Need to increment the month because it is
zero-based
int c = currentCalendar.get(Calendar.DATE);
String currentDate = a + "-" + b + "-" + c; //Format
the date for DB2
Does that seem absurd?
Eytan
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> Martin Kuba
> Sent: Tuesday, July 13, 1999 9:40 AM
> To: [EMAIL PROTECTED]
> Subject: Re: How do I set the current date thru JDBC.
>
>
> Brian Silberbauer wrote:
> >
> > The java.sql.Date class does not handle hours, minutes or
> seconds. If you need
> > to insert the exact time into a SQL database I suggest create a
> string the
> > database recognizes and then inserting the string. This works:
> >
> > ////////////////////////
> > java.util.Date utilDate = new Date();
> > SimpleDateFormat sdf = new SimpleDateFormat("MMM dd yyyy hh:mmaa");
> > String stringDate = sdf.format(utilDate).toString();
> >
> > ............. later ....
> >
> > pstmt.setString(1, stringDate);
> > //////////////////////////
> >
> > where pstmt is a prepared statement (in this case)
>
> NO ! You should let the JDBC driver do this job. If you need
> to store exact time and date use the type java.sql.Timestamp:
>
> java.util.Date now = new java.util.Date();
> java.sql.Timestamp ts = new java.sql.Timestamp(now.getTime());
> ...
> pstmt.setTimestamp(1,ts);
>
> Martin
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> INET, a.s. Mgr. Martin Kuba
> Kralovopolska 139 e-mail: [EMAIL PROTECTED]
> 601 12 Brno WWW: http://www.inet.cz/~makub/
> Czech Republic tel: +420-5-41242414/33
> --------------------------------------------------------------------
> PGP fingerprint = D8 57 47 E5 36 D2 C1 A1 C3 48 B2 59 00 58 42 27
> http://wwwkeys.cz.pgp.net:11371/pks/lookup?op=index&search=makub
> --------------------------------------------------------------------
>
> __________________________________________________________________
> _________
> 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
