SEO

Hi,

My Object is java.util.Date ... first of all;
I make an instance of the Date object

Date date = new Date();

then

I am wirting the set methods of the preparedstatement as

query.setDate(1,date);

however eclipse gives an error message, which is "The method
setDate(int, Date) in the type PreparedStatement is not applicable for
the arguments (int, Date)"...
<b>(but eclipse say that it can!)</b>

so sorry for stack trace but I cant even compile it yet...

I need time of the day, and the date... timezone and other staff is not
important...

13/10/2005 11:30 .. or something like this is enough for me ...



Kevin Grittner wrote:

>Hi,
>
>Is your object a java.util.Date, a java.sql.Date, or a
>java.sql.Timestamp? Do you want the column in the database to
>store only a date, or combined date and time? If you want the
>column to store a combined date and time, you should define it
>as TIMESTAMP WITH TIME ZONE unless you have some very
>unusual need to have a timestamp that represents a different
>moment in each time zone.
>
>Some sample code and your exception (with stack trace) would
>help, too.
>
>-Kevin
>
>
>
>>>>Ayd*n Toprak <aydin.toprak@intengo.com> 10/13/05 1:20 AM >>>
>>>>
>>>>
>hii,
>
>
>I am newbie for jdbc-postgres and looking for some help about timestamp
>type of posgresql.....
>
>
>my porgram makes a data object, and then insert this object to the db.
>however, I couldnt been able to insert date object directly to the db as
>timestamp ...
>
>do I making something wrong ? .. or is there another type to keep full
>date of java, in the Postgresql Db.
>
>Thank You.
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>
>
>
>

Aydın Toprak schrieb:

> Hi,
>
> My Object is java.util.Date ... first of all;
> I make an instance of the Date object
>
> Date date = new Date();
>
> then
>
> I am wirting the set methods of the preparedstatement as
>
> query.setDate(1,date);
>
> however eclipse gives an error message, which is "The method
> setDate(int, Date) in the type PreparedStatement is not applicable for
> the arguments (int, Date)"...
> <b>(but eclipse say that it can!)</b>
>

You need to convert java.util.Date to java.sql.Date if you want only to
store the date without the time in a database field DATE. Then you can
use setDate().

If you want to store it in a database field TIMESTAMP you must convert
the java.util.Date to java.sql.Timestamp. Then you can use

query.setTimestamp(1, timestamp);

If you use setDate with an java.sql.Date here, you loose the information
of the time, even if the Database field is of the type TIMESTAMP.

The conversion works as the following, i. e.:

java.util.Date date = new java.util.Date(System.currentTimeMillis());
java.sql.Timestamp timestamp = new java.sql.Timestamp(date.getTime());

It is the same for the conversion to java.sql.Date.

Regards,
Roland.

--
Roland Walter phone: +49 (0) 22 25 / 88 2-41 1
MOSAIC SOFTWARE AG fax: +49 (0) 22 25 / 88 2-20 1
Am Pannacker 3 mailto: rwa (at) mosaic-ag (dot) com
D-53340 Meckenheim http://www.mosaic-ag.com

------- L E G A L D I S C L A I M E R ---------

Die Informationen in dieser Nachricht sind vertraulich
und ausschliesslich fuer den Adressaten bestimmt.
Kenntnisnahme durch Dritte ist unzulaessig. Die
Erstellung von Kopien oder das Weiterleiten an weitere,
nicht originaere und benannte Adressaten ist nicht
vorgesehen und kann ungesetzlich sein. Die Meinungen
in dieser Nachricht stellen lediglich die Meinungen
des Senders dar. Falls Sie vermuten, dass diese
Nachricht veraendert wurde, setzen Sie sich mit dem
Absender in Verbindung. Der Absender uebernimmt ohne
weitere Ueberpruefung keine Verantwortung fuer die
Richtigkeit und Vollstaendigkeit des Inhalts. Unbefugte
Empfaenger werden gebeten, die Vertraulichkeit der
Nachricht zu wahren und den Absender sofort ueber
einen Uebertragungsfehler zu informieren.
------------------------------------------------------


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thanks for your help.
It was very accurate and worked.


Roland Walter wrote:

> Aydın Toprak schrieb:
>
>> Hi,
>>
>> My Object is java.util.Date ... first of all;
>> I make an instance of the Date object
>>
>> Date date = new Date();
>>
>> then
>>
>> I am wirting the set methods of the preparedstatement as
>>
>> query.setDate(1,date);
>>
>> however eclipse gives an error message, which is "The method
>> setDate(int, Date) in the type PreparedStatement is not applicable
>> for the arguments (int, Date)"...
>> <b>(but eclipse say that it can!)</b>
>>
>
> You need to convert java.util.Date to java.sql.Date if you want only
> to store the date without the time in a database field DATE. Then you can
> use setDate().
>
> If you want to store it in a database field TIMESTAMP you must convert
> the java.util.Date to java.sql.Timestamp. Then you can use
>
> query.setTimestamp(1, timestamp);
>
> If you use setDate with an java.sql.Date here, you loose the information
> of the time, even if the Database field is of the type TIMESTAMP.
>
> The conversion works as the following, i. e.:
>
> java.util.Date date = new java.util.Date(System.currentTimeMillis());
> java.sql.Timestamp timestamp = new java.sql.Timestamp(date.getTime());
>
> It is the same for the conversion to java.sql.Date.
>
> Regards,
> Roland.
>


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match