Hi there I am trying to insert a Date object into a database. The date is inserted,
but not the time. Why could this be?

I am using a prepared statement and setDate (the "photo" object in the below contains
a java.util.Date object, from which I create a java.sql.Date object - I am sure there
is a time on this Date object):

stmt.setDate( 4, new java.sql.Date( photo.getDate().getTime() ) );

but on the insert it is only the date that ends up in the DATE column.

Thanks, Peter.

Peter Kirk <peter_kirk@alpha-gruppen.dk> wrote:
  > The date is inserted, but not the time. Why could this be?

Check what kind of field you are insertint into. If it's a DATE field maybe the time
is set to 0 automatically.

Davide

<davide@yahoo.com> wrote in message news:akneip$1k61g4$4@ID-18487.news.dfncis.de...
  > Peter Kirk <peter_kirk@alpha-gruppen.dk> wrote:
     > > The date is inserted, but not the time. Why could this be?
  > Check what kind of field you are insertint into. If it's a DATE field maybe the
  > time is set to 0 automatically.
  > Davide

Hi, thanks for the reply. Yes, the field is a DATE field. Do you think the database
might just set the time to 0?

I can get it to work if I make a timestamp instead: stmt.setTimestamp( 4, new
java.sql.Timestamp( photo.getDate().getTime() ));

This inserts as I expect into the DATE field.

Peter.

Peter Kirk <peter_kirk@alpha-gruppen.dk> wrote:
  > Yes, the field is a DATE field. Do you think the database might just set the
  > time to 0?

It's possible, or he just does not show the time because it's a DATE field. Try using
a TimeStamp or DATETIME field type.

  > This inserts as I expect into the DATE field.

Then the driver cut off the time when you are using Date. Use Timestamp instead.

Davide