I have some date in Oracle that are stored in this format 5/13/2008 11:10:53 AM ... I'm trying pass a variable into Oracle from a Crystal Report... I'm using "and trunc(b.create_time) = to_date(p_date, 'DD- Mon-YYYY');" but I keep getting "Failed to retrieve data from the database"... any formatting ideas? Thanks!
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
