Hi<BR><BR>I am try to compare a VARCHAR field that stores a date as:<BR><pre class="ip-ubbcode-code-pre"> to_char(DateTimeField, 'MM-DD-YYYY') <> to_char(to_date ...
Are you looking to become an Oracle Database SQL Certified Associate? The Oracle 1Z0-071: Oracle Database SQL exam is a crucial step for those who want to prove their understanding of foundational SQL ...
i) to_char(): This function converts the oracle date into character format and the format must be specified in single quotes Syntax: to_char(date,'FORMAT') select to_char(sysdate,'DD/MM/YYYY') from ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results