Skip to Main Content
Forums

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!

TRUNC date to Semester?

645597Jun 17 2008 — edited Jun 19 2008
I know I can truncate a date to year, quarter or month using TRUNC. But is there anyway I could easily truncate it to semester?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2008
Added on Jun 17 2008
11 comments
8,766 views