Results 1 to 2 of 2

Thread: Ora-01843

  1. #1
    Join Date
    Nov 2001
    Location
    Baton Rouge
    Posts
    13

    Unanswered: Ora-01843

    I am getting this error ORA-01843
    I am not sure how to rectify this error message. I ma trying to insert data in my tables.
    please help
    Thanks

  2. #2
    Join Date
    Jan 2002
    Location
    italy
    Posts
    39
    ORA-01843 not a valid month

    Are you inserting a date into a table?

    Assuming a table (my_table) with a field (my_date) of datatype DATE

    Try this way:

    INSERT INTO my_table (my_date)
    VALUES (TO_DATE('12/01/2000','dd/mm/yyyy'));

    specifying that the format mask is 'dd/mm/yyyy'
    and everithing should go

    You can set a default date format mask in the init file (NLS_DATE_FORMAT=...) and override this value in your own session
    (alter session set NLS_DATE_FORMAT=...)

    hope this helps
    astropp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •