[Squirrel-sql-users] Dateformat in Oracle
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: LeO W. <le...@gm...> - 2007-11-28 09:44:54
|
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? LeO -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail |