Re: How to insert "date" as timestamp

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.
>