What apps for windows 7 are there for night work?

Question

Windows

I am looking for a convenient program for adjusting the backlight and other parameters so that it is convenient to work at night. I remember that I used to come across programs that change the gamut of colors to the most suitable for night work.

Answer 1

f.lux allows you to change the color temperature of the monitor in a fairly large range.

Answer 2

It is better to turn on the light and do not spoil your eyesight.

Answer 3

something like this:

SELECT t1.name, UNIX_TIMESTAMP(t1.create_time) - UNIX_TIMESTAMP(t2.create_time) as second -- время между событиями в секундах
FROM ticket_history  t1
INNER JOIN ticket_history t2 ON t2.ticket_id = t1.ticket_id AND t2.hystory_type_id=2 -- открытие тикета
WHERE t1.hystory_type_id=15  -- закрытые тикеты

Answer 4

I don't think the design is right. If these are logs, this is one thing, and if the worksheet is with tickets, then it is better to specify the creation time and closing time in adjacent fields, and simply subtract in the select, getting this intermediate time. This is much simpler and more correct.
And so, as a bicycle, you can select the ticket opening time with a subquery, then the closing time, and take it away.
If I see a real select ticket with fields and data, I can compose

Answer 5

select ticket_id, UNIX_TIMESTAMP(datetime) - UNIX_TIMESTAMP(datetime) as diff_seconds from tablename join (
select ticket_id, datetime from tablename where /* тип=закрыть */
) tclose USING(ticket_id)
WHERE /* тип=новая заметка */

?