Can I retrieve the data between 2 specified dates and falling between 4th hour of Monday and 10th hour of Thursday everyweek.
Note: The 2 dates, the starting weekday,hour and ending weekday, hour...
Type: Posts; User: Vasanth.sql; Keyword(s):
Can I retrieve the data between 2 specified dates and falling between 4th hour of Monday and 10th hour of Thursday everyweek.
Note: The 2 dates, the starting weekday,hour and ending weekday, hour...
appreciate your quick reply. The above solution works if i have a date column but not the day of week string ( mon, tue etc) i have a sub query. My requirement is get the data for all the weekdays of...
I am having the select statement which is returning me the Day of the Week,ie. Mon, Tue, Wed etc.
I need to order these days starting from Sunday and ending on Saturday.
Kindly let me know how to...