Thursday, November 21, 2002 07:41 AM
Hi guys. I want to know how I can internationalize the date conversion in my SQL queries, stored procs, and triggers (from here known as queries) in Oracle. Currently, what we do to convert chars to dates is "to_date('mm/dd/yyyy', dateParam)'. This have been working fine until recently when we decided to internationalize our app that the "dateParam" we passed to the queries does not necessarily follow the "mm/dd/yyyy" format anymore.
Any help would be greatly appreciated. Thanks.