What is easiest and effective way to fetch data based on time Zone.

I create a table using the following SQL.

I can’t store the path of the images in the database. I’ve already tried storing it in varchar 255 and already done the path from c: but without success. What would be the correct way to store an image in mysql? I send images to try to understand how to do it, I’ve already tried all possible ways start from c:

Okay, I’m absolutely flummoxed trying to understand what’s going on here.

I’m having a hard time with this query, thanks in advance for the help!

I have a query that includes two WITH clauses. The first one, ‘feriados’, returns every day between the start date and end date from a row in a table named ‘holidays’. A holiday may start and end on the same day or have different start and end dates. The second clause defines a function named ‘data_distinta’, which determines whether a day is a valid work day or not. A valid work day is defined as a day that is neither a weekend nor a holiday (being a holiday is filtered by the ‘feriados’ function). When it’s a valid work day, the function returns 1; otherwise, it returns 0.

This is a question for those MySQL (8.2.0) experts out there.

I am designing the database structure of a project and I faced the following question.