Re: Date Type Problem

DINFA - Microcentro wrote:
>
> Hi,
>
> I read several messages about Date Problems. I have followed some clues
> but still have a problem:
> I changed the NLS_DATE_FORMAT Parameter at init.ora to "YYYY-MM-DD"
> format and reinicialized the database instance.
> I have a table TAB1 that has a Date type column and when i make a select
> statement i get, for instance, 98.01.01. If i try to insert a value in
> that column like '1998-01-01' an error occurs: "ORA-01830: Date Format
> Picture ends before converting entire input string". If i do Alter
> Session set nls_date_format = 'YYYY-MM-DD' i have no problem, but i want
> the Default Date Format to 'YYYY-MM-DD'.
> Please i need Help!!
>
> Thanks in Advanced

Check that you haven't set a NLS_DATE_FORMAT in a login.sql (or glogin.sql)
(for login on the UNIX system).
If you use a PC-client ensure that your enviroment is set to the correct format (e.g. check the registry in NT/WIN95).

rgds
eugen Received on Wed Feb 25 1998 - 00:00:00 CST