|
[oracle-l]
||
[Date Prev]
[04-2005 Date Index]
[Date Next]
||
[Thread Prev]
[04-2005 Thread Index]
[Thread Next]
RE: Date datatype
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <anwarsk@xxxxxxxxx>
- Date: Tue, 5 Apr 2005 07:39:41 +0200
Hi
> 1.. In SQLPlus, how can I display the full value
> of a date column? I mean date and time and not
> only the date.
One possibility is to set the parameter NLS_DATE_FORMAT at session level =
to something like "DD.MM.YYYY HH24:MI:SS".
> 2.. I'm trying the EXTRACT function. Year, month and
> day worked fine but not the hour, minute and
> second. How can I do it?
It should work. What does it mean "... but not..."?=20
If you copy/paste an example it's easier to help you...
> 3.. I tried to add a numeric value from another
> field to a date column and it worked for the
> date. Is it possible to do the same thing with the time?
Yes. E.g. add 1/24 to add one hour... i.e. you should do some math...
HTH
Chris
--
http://www.freelists.org/webpage/oracle-l
|
|
