Examples for validating dates in plsql
The result of his query was: my Date Column TO_DATE(my Date Column) TO_CHAR(my Date Column,'DD-MON-YYHH. SSPM') TO_CHAR(my Date Column,'YYYY') 14-Feb-11 14-Feb-11 14-FEB-11 AM 0011 14-Feb-11 14-Feb-11 14-FEB-11 AM 0011 14-Feb-11 14-Feb-11 14-FEB-11 AM 0011 14-Feb-11 14-Feb-11 14-FEB-11 AM 0011 14-Feb-11 14-Feb-11 14-FEB-11 AM 0011 Your belief that this should not be necessary is correct based on your assumptions.
Normally this means the assumptions should be rechecked (unless there is data corruption or a bug).
Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. The reason why I ask is because this select/ where will be part of a stored procedure selecting data within a specific date range to be run on a big table partitioned by date, with more than ten million rows, and if I can avoid explictly converting each my Date Column of each row, then I might be able to save some query time, in theory.
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Or is there a more correct way to run this comparison to select data within a date range? Update: Leigh suggested in the answer to diagnose the table for something inconsistent with his query.
Import CLOB - A simple method for importing the contents of a file into a CLOB datatype.
Inter Media - Import-Export Of Images - Prior to Oracle 8.1.7 the inter Media support for import and export of data was a little flunky.
Data Encryption - DBMS_OBFUSCATION_TOOLKIT - Encrypt and decrypt data using the DBMS_OBFUSCATION_TOOLKIT package.
File Handling From PL/SQL - Perform basic file manipulation from PL/SQL using this simple API.
Import BLOB - A simple method for importing the contents of a file into a BLOB datatype.
Bulk Binds - Improve performance by reducing the overhead associated with context switches between the PL/SQL and SQL engines.
Collections in Oracle PL/SQL - Use collections in PL/SQL to perform array processing.
CASE Expressions And Statements - Learn how to use CASE expressions in both SQL and PL/SQL.