Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle and dates

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have been working on this problem in oracle for days and can't figure it out.

"Show all employees who were hired in the first half of the month."

Does anyone know how to show less then the first half of the month?
 
to_number(to_char(my_date, 'dd')) < 15

may be an approach I tried to remain child-like, all I acheived was childish.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top