Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

:: Double colon in SQL

user4782898May 9 2014 — edited May 9 2014

Hi,

   Can someone please tell me what is :: doing in this statement

      DECODE(to_char(gar.a_date::date,'MM/DD/YYYY'),NULL,'Unknown',to_char(gar.a_date::date,'MM/DD/YYYY')) as A_Date

Thanks

Aali

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2014
Added on May 9 2014
3 comments
2,099 views