Select dates

Question

Select dates

Navigation

#1 by (1 votes)
#2 by (0 votes)

3

I need to make a select that brings me instances that the start date of a license is less than 3 years from an employee's date of admission

Below is an excerpt from my code.

SELECT *
FROM
    jmh_licenca l
    INNER JOIN
    jmh_servidor s on l.lic_ser_id = s.ser_id
    INNER JOIN
    jmh_doenca d ON l.doe_id = d.doe_id 
WHERE
    l.lic_data_inicial BETWEEN '2012-08-01' AND '2015-08-01' AND
    l.lic_data_inicial **< (3anos)** s.ser_data_admissao AND
    tip_lic_id in ('9', '12');

mysql sql postgresql

asked by anonymous 02.12.2015 / 13:35

2 answers

Mysql query intervals Help with onitemclick listview

score 1 · Answer 1

Try the following code:

SELECT * FROM jmh_licenca l
INNER JOIN jmh_servidor s on l.lic_ser_id = s.ser_id 
INNER JOIN jmh_doenca d ON l.doe_id = d.doe_id 
WHERE l.lic_data_inicial
BETWEEN '2012-08-01' AND '2015-08-01' 
AND l.lic_data_inicial < s.ser_data_admissao - INTERVAL '3 Year' AND tip_lic_id in ('9', '12');

score 0 · Answer 2

select *
from
    jmh_licenca l
    inner join
    jmh_servidor s on l.lic_ser_id = s.ser_id
    inner join
    jmh_doenca d on l.doe_id = d.doe_id 
where
    l.lic_data_inicial between '2012-08-01' and '2015-08-01' and
    l.lic_data_inicial::timestamp - s.ser_data_admissao < interval '3 years' and
    tip_lic_id in ('9', '12');