Re: Dateformat in Oracle

On Nov 28, 2007 4:44 AM, LeO Welsch <leo_zen@xxxxxx> wrote:
> Hi,
>
> Is there a reason, why when I select a Column with Format Date the result is 
> only the Date and the Time is truncated.
>
> I mean I could easily retrieve it via
>
> to_char(UPDATE_TIME, 'YYYY.MM.DD HH24:MM:SS')
>
> but couldn't be this format set as default format for Date?

Hello,

It is true that Date columns in Oracle have a time component.  The SQL
standard however says that DateTime columns have Date and Time whereas
Date columns only have a Date value.  Most vendors including Sun's
JDBC spec don't support Date columns with a time component.  However,
JDBC does allow you to retreive a Date as a Timestamp, presumably to
support databases like Oracle.  That behavior can be configured in
Global Preferences -> Data Type Controls -> "Interpret Date column as
Timestamp".  However, this setting is Oracle-specific and may not work
well with other databases.  At some point this capability will be
moved to the Oracle plugin.  Still, you should be able to use it to
accomplish what you requested.

Rob

-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4