Re: Date datatype

Thank you all for the help.

Anwar Saleh Khudhair
----- Original Message -----
From: "Barbara Baker" <barb.baker_at_gmail.com> To: <anwarsk_at_gmail.com>
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_at_gmail.com> 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
>> --
>> http://www.freelists.org/webpage/oracle-l
>>

--
http://www.freelists.org/webpage/oracle-l