Re: [JBoss-dev] java.util.Date in PostgreSQL DB

[Victor Langelo]

David Budworth wrote:

[EMAIL PROTECTED]">

Or does PostgreSQL DATE/TIMESTAMP exactly the same?  I know oracle will
drop the time portion if the column type is DATE.

-David

Actually Oracle will not drop the time protion if the column type is DATE. The following is from the Oracle 8 manual. Oracle 7 says essentially the same thing.

The DATE datatype stores date and time information. Although date and time information can be represented in both CHAR and NUMBER datatypes, the DATE datatype has special associated properties. For each DATE value, Oracle stores the following information: century, year, month, day, hour, minute, and second.

You need to use TRUNC(date) in order to remove the time portion (or more accurately set it to 0).

--Victor

[EMAIL PROTECTED]">