How to convert oracle dates into weeks

This article will explain in detail how to convert oracle dates into weeks. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Now there is a job of data analysis, which needs to analyze some of the registered members of the website:

1. Members registered on working days and working hours become paid members.

two。 Members registered on weekdays and non-working hours become paid members.

3, non-working days, non-working hours registered members become paid members of the list.

4. Members registered during non-working days and working hours become paid members.

Working hours: 08:30 to 17:30

Weekdays: Monday to Friday.

Check the total number of registered members during working days and working hours:

Select count (*) from member_info1234 where to_char (register_date,'d') > 1 and to_char (register_date,'d')'08 and to_char 0012 and to_char (register_date,'HH24:mi:ss') 1 and to_char (register_date,'d')'08 and to_char (register_date,'d') 1 and to_char (register_date,'d')'08 and to_char (register_date) 'HH24:mi:ss') 1 and to_char (register_date,'d')' 08VV 0000' and to_char (register_date,'HH24:mi:ss')