tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stéphane BAUDET <sbau...@gltrade.fr>
Subject Re: Dates in Java
Date Fri, 06 Apr 2001 12:45:36 GMT
Are we in the tomcat-user forum ??? 
I don't see the relationship between a so simple constructor problem
(which Javadoc solve quiet easily ...) and Tomcat ...


Alistair Hopkins a écrit :
> 
> try "select myDate - 7 from myTable;" in your SQL statement for a quick fix
> :-)
> (works on postgres, don't know about msql)
> 
> -----Original Message-----
> From: Michael Wentzel [mailto:Michael.Wentzel@aswethink.com]
> Sent: Friday, April 06, 2001 12:58 PM
> To: 'tomcat-user@jakarta.apache.org'
> Subject: RE: Dates in Java
> 
> I have a simple question about the Date object (or similar object)
> 
> I have a mySQL table with a DATETIME cell. I want to get the date from this
> cell
> 
> (formatted like so: e.g.  2001-03-23 13:04:59)
> 
>  and retrieve the date that is exactly 7 days earlier than the retrieved
> date.
> 
> What is the easiest way to do this? I noticed a lot of method deprecations
> in the specs and I am having trouble using the Date object.
> -----
> For example,
> DateTest.java:20: cannot resolve symbol
> symbol  : constructor Date  ()
> location: class java.sql.Date
>                 Date d = new Date();
>                          ^
> 1 error
> 
> -----
> 
> ----------------------------------------------------------------------------
> ---------
> First, in regards to displaying your date use the java.text.DateFormat
> class(note DateFormat
> is abstract so of course you'll want to use one of the 'implementation'
> classes).  Since
> java.sql.Date extends java.util.Date you can of course use the
> java.text.DateFormat classes
> to format a java.sql.Date.
> 
> Secondly, the problem you are having using java.sql.Date could be if you are
> importing java.util.*.  This will import java.util.Date in addition to
> java.sql.Date.
> Therefore, when you code Date d = new Date() the compiler doesn't know which
> classdef
> to use.  One solution to to not import anything using splay(*).  This is the
> way we
> do it.  You import block may get a little large but it also makes it easier
> for other
> developers to figure out where to look for source.  Another is to code it as
> java.sql.Date d = new java.sql.Date();
> 
> ---
> Michael Wentzel
> Software Developer
> Software As We Think - http://www.aswethink.com

-- 
Cordialement,


Stéphane BAUDET

_________________________________________________________
GL Trade
48, rue Notre Dame des Victoires - 75002 Paris
Tel : 01 53 40 43 12 (interne 1312)
Fax : 01 53 40 01 40
Email : sbaudet@gltrade.fr
_________________________________________________________

Mime
View raw message