Home > database >  Inquired database sort by date and week?
Inquired database sort by date and week?

Time:11-19


Could you tell me how to date column week according to the Sunday, Monday, to sort on Saturday?
Is currently a SELECT * FROM table ORDER BY asc equipment name, date of asc, but week didn't row,

CodePudding user response:

It should be said that week sorting is not I want results,

CodePudding user response:

You this makes little sense to sort, both the specific date, have a fixed weekly date again, and every day, should add a type fields, such as daily, weekly, or only happens once, similar to SQL job scheduling setting function,

Do you really want to sort, then convert several weeks to a fixed value of the order, such as into 1 on Monday, Tuesday, converted to 2, and so on, but might be confused and specific dates,
  • Related