Re: Date datatype
- From: "Anwar Khudhair" <anwarsk@xxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 Apr 2005 14:40:58 -0700
Thank you all for the help.
Anwar Saleh Khudhair
----- Original Message -----
From: "Barbara Baker" <barb.baker@xxxxxxxxx>
To: <anwarsk@xxxxxxxxx>
Sent: Tuesday, April 05, 2005 8:35 AM
Subject: Re: Date datatype
> Anwar:
> Regarding question 1:
> The format of the date/time is controlled by the parameter
> nls_date_format.
> To see how it is currently set for your session:
>
> select * from nls_session_parameters
> where parameter='NLS_DATE_FORMAT';
>
> To change it, you can for example:
> alter session set nls_date_format ='DD-MON-YYYY HH24:MI:SS';
>
> HTH.
> Barb
>
>
> On Apr 5, 2005 10:32 AM, Anwar Khudhair <anwarsk@xxxxxxxxx> wrote:
>> Hello list,
>>
>> Three questions about the Date datatype. Thanks in advance for your help.
>>
>> 1.. In SQLPlus, how can I display the full value of a date column? I
>> mean date and time and not only the date.
>> 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?
>> 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?
>>
>> Anwar Saleh Khudhair
>> --
>> //www.freelists.org/webpage/oracle-l
>>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
