The TO_DATE function, for some reason, does not cast to DATE data-type. Instead, it is just an alias for TIMESTAMP_FORMAT. Also, if the host variable isn't a character data type, you have to wrap the ...

exec dbms_sqltune.drop_sql_profile('my_sql_profile',TRUE); exec dbms_sqltune.drop_sql_profile('my_old_sql_profile',TRUE); exec dbms_sqltune.drop_sql_profile('my_sql ...

description Reference for the CAST and CONVERT Transact-SQL functions. These functions convert expressions from one data type to another.

SQL, or Structured Query Language, is a widely used language for manipulating data in relational databases. SQL allows you to perform various operations on data, such as querying, inserting, updating, ...