But this time I need to add day too because some rows StartDate is being previous day and EndDay is being current day so the precious days hours mixing current day hours.

By the way continue of that SQL command, I trying to get daily records with group by hours.

Logic on sql side is not good idea. But for do if u can try to use literal

Okay I will try with it too. Thank you so much.

U are welcome

As u said I used thi column as literal and I get my target result, thank you again.

Hello,
I use MySql with Sequelize 5.21.12, trying to add below in attributes array at findAll function;

[sequelize.literal(`DATE_FORMAT(IF(StartDateTime<${startDate},${startDate},StartDateTime), "%Y/%m/%d/%H")`), 'StartYMDH']
by the way I use moment.js and the startDate  a +3 GMT date but database is +00

Database thwor an error because of date that sequelize running as below;

DATE_FORMAT(IF(StartDateTime<Wed Dec 09 2020 00:00:00 GMT+0300,Wed Dec 09 2020 00:00:00 GMT+0300,StartDateTime), "%Y/%m/%d/%H") AS StartYMDH,

how can I fix that code?

Show error message

It seems I just solved after hours and just after asked here ☺️ with chande ${startDate} wtih

< '${startDate.utc().format("YYYY-MM-DD HH:mm:ss")}',

added ' icon before and after and user utc().format()

But now I am getting onather error that
"Unknown column 'Works.StartYMDH' in 'order clause'"

See result error for debug

It is faster way

the error result show the order name is not belongs to table I am trying to order with the name that I added ttribute
order: ['StartYMDH']

sequelize adding table name before that name like
ORDER BY Works.startYMDH
startYMDH is not a column of Works table it is just added in attribute array

Спасибо, решилось

Всем, привет! Коллеги подскажите практику как можно сделать дубликат модели и туда заносить записи из другой модели, для введение актуальной истории записей без изменение модели оригинала

Есть какие то практики или почитать что нить по этому вопросу

Обычно использую тригеры для этого.

коллеги ,  кто нибудь сталкивался с такой ошибкой

если удалить  эти 4 маршрута то все заработает

все разобрался извиняюсь тут моя ошибка