|
-
i have problem
can i able to enter date in this format if i set
nls_date_format = "YYYY-MM-DD HH24:MI:SS"
in INIT.ORA
when i am trying to insert the date into table problem
SQL>create table adate(dats date);
Table created
SQL>insert into adate values('2001-02-03 23:42:02');
ORA -01861 literal does not mach format string
RAMESH
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|