Oracle Varchar to Oracle Date

[dprasanth]

"ISO format" for dates means ISO 8601, which is an international standard for how to format dates, timestamps, times. The standard date format is YYYY-MM-DD.

ISO8859 (various parts) is a standard relating to encoding of characters, and is irrelevant on this thread. NLS character maps don't come into it at all. However, if you have NLS enabled, check that your locale TIME category has been chosen appropriately.

When I referred earlier to "MDY" instead of "DMY", I meant in the Oconv() and Iconv() functions, not in SQL.

Thanks for that information