MariaDB Request

Completado Publicado hace 3 años Pagado a la entrega
Completado Pagado a la entrega

Hello,

i have on my Debian Server MariaDB running.

Now i need a Request to check the days beetween rows.

i have attached a example database.

in the result i want to see as example all dates between the rows who are shorter than 3 days in room 4 ( see attached image )

example result: 4 20201220 20202022

Sysinfo: Ver 10.1.47-MariaDB-0+deb9u1 for debian-linux-gnu on x86_64 (Debian 9.13)

Linux PHP MariaDB

Nº del proyecto: #28333362

Sobre el proyecto

6 propuestas Proyecto remoto Activo hace 3 años

Adjudicado a:

pawelwtorek

Hi, Can you clarify: do you need query to show dates between rows or between columns (from and to) ? This is not the same, but i suspect you need difference between columns (from and to) I recommend myself regards

€19 EUR en 1 día
(1 comentario)
1.8
ksab

The check can be done using PHP code after reading the values from the database. please let me know if the difference of days you are check is from the from date and to date or the difference between end date of one r Más

€19 EUR en 1 día
(22 comentarios)
4.0

6 freelancers están ofertando un promedio de €24 por este trabajo

kreativesystem91

Hi, nice to greet you, my name is Alex, I would be interested in working on your project, I have immediate availability I remain attentive to your comments Cheers

€15 EUR en 7 días
(65 comentarios)
5.0
gattes

Hi there, I have over 10 years of work experience with Linux and DBs I think I can help you with this. Ping me and I'll do so. Cheers mate.

€30 EUR en 1 día
(17 comentarios)
4.4
naasirlampard

I am an employee who is ready to help or assist you in his or her work; I am an IT designer, Video editor, Web designer & Developer, Programmer, Big IT networker and many more. I studied Computer Science & Network Cybe Más

€19 EUR en 7 días
(0 comentarios)
0.0