Hmm, weird. Because I have actually used Date before, and had the time dropped off.
Maybe it has something to do with the JDBC drivers conversion of java.util.Date -> jdbc type DATE -> SQL type DATE? Ohwell, it works as timestamp, so I won't worry about it for now. Thanks for the info, -David On Tue, 12 Feb 2002, Victor Langelo wrote: > David Budworth wrote: > > > > >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 > _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
