You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cayenne.apache.org by Tony Dahbura <da...@aopslab.com> on 2011/06/07 01:01:15 UTC

Quick question about Date and Time database types

I have a mysql database we are using with Cayenne...The column type in mysql is datetime. 

When accessing the returned objects in Cayenne they all have the time set to 00:00:00 but the date is valid. The mysql database has the time and date correct. 

The java date object is able to handle the time... 

Not sure what Cayenne is doing to the time portion of the date? 

It is a straight query against the database to return a list of objects.... 

Thanks, 
Tony

Re: Quick question about Date and Time database types

Posted by Tony Dahbura <da...@aopslab.com>.

That worked.  I used a java.sql.timestamp in the modeler for it.

In the past used to have issues with java.sql.timestamp...Cayenne seems to not have any issues with them!!!

Tony


----- Original Message -----
From: "Michael Gentry" <mg...@masslight.net>
To: "Cayenne Users" <us...@cayenne.apache.org>
Sent: Tuesday, June 7, 2011 9:29:47 AM
Subject: Re: Quick question about Date and Time database types

Hi Tony,

I think you may want a Timestamp instead.

mrg


On Mon, Jun 6, 2011 at 7:01 PM, Tony Dahbura <da...@aopslab.com> wrote:

> I have a mysql database we are using with Cayenne...The column type in
> mysql is datetime.
>
> When accessing the returned objects in Cayenne they all have the time set
> to 00:00:00 but the date is valid. The mysql database has the time and date
> correct.
>
> The java date object is able to handle the time...
>
> Not sure what Cayenne is doing to the time portion of the date?
>
> It is a straight query against the database to return a list of objects....
>
> Thanks,
> Tony
>
>
>
>

Re: Quick question about Date and Time database types

Posted by Michael Gentry <mg...@masslight.net>.

Hi Tony,

I think you may want a Timestamp instead.

mrg


On Mon, Jun 6, 2011 at 7:01 PM, Tony Dahbura <da...@aopslab.com> wrote:

> I have a mysql database we are using with Cayenne...The column type in
> mysql is datetime.
>
> When accessing the returned objects in Cayenne they all have the time set
> to 00:00:00 but the date is valid. The mysql database has the time and date
> correct.
>
> The java date object is able to handle the time...
>
> Not sure what Cayenne is doing to the time portion of the date?
>
> It is a straight query against the database to return a list of objects....
>
> Thanks,
> Tony
>
>
>
>