Can to_date() handle am/pm date values? I am trying to extract the last run datetime value using an SQL function, for which I need the time as well. For datetime format, with the SQL function, it doesn't return the time. For timestamp it returns the time... but in this
format: 09-DEC-09 01.06.22.664000 PM If I use this: to_date('09-DEC-09 01.06.22.664000 PM','dd-...