Date/Time format

jruthes · **Joined:** Wed Jul 07, 2004 12:44 pm **Posts:** 2

Hello,

Look the following code:

Java class

Code:

public class Carga 
{
   private long id;
   private Date dtFaturamento;
...
...
   get's
   set's
}

Hibernate mapping

Code:

<hibernate-mapping>
    <class name="com.Carga">
        <id name="id" type="long">
   <generator class="native"/>
      </id>
    <property name="dtFaturamento" type="date"/>
</hibernate-mapping>

Struts - Web Tier (Jsp)

Code:

<bean:write name="carga" property="dtFaturamento" format="dd/MM/yy HH:mm"/>

Result

21/06/04 00:00

Using SQLPLUS (Oracle 9.2)

Code:

SELECT TO_CHAR(DTFATURAMENTO,'DD/MM/YY HH:MI') FROM CARGAS;

Result
TO_CHAR(DTFATURAMENTO)
--------------
21/06/04 04:56

How can I get Date/Time format using Hibernate?

Is it possible to define what format I need to get in <property> TAG
Something like this

Code:

christian · **Posted:** Wed Jul 07, 2004 1:22 pm

Dates and times in Java and Oracle don't work like that. There is no "format", just a Date object with format-independent date and time information. The same is true for Oracle date/time data types.

Myk · **Joined:** Sun Jan 04, 2004 2:46 pm **Posts:** 147

If you're having trouble with the time's always being 00:00:00, ie only getting the date, change the property type from date to timestamp.

jruthes · **Joined:** Wed Jul 07, 2004 12:44 pm **Posts:** 2

Myk wrote:

If you're having trouble with the time's always being 00:00:00, ie only getting the date, change the property type from date to timestamp.

Thanks a lot..

It solved my problem...