1. SQL / Говнокод #28606

    −5

    1. 1
    2. 2
    3. 3
    4. 4
    5. 5
    6. 6
    7. 7
    8. 8
    VALUE1 in (
	   (extract(year from '2023-11-01 00:00:00'::date-interval'1 year')::varchar(4)||'-12-31')::date,
	   (extract(year from '2022-11-01 00:00:00'::date-interval'1 year')::varchar(4)||'-12-31')::date, 
	   (extract(year from '2021-11-01 00:00:00'::date-interval'1 year')::varchar(4)||'-12-31')::date,
	   (extract(year from '2020-11-01 00:00:00'::date-interval'1 year')::varchar(4)||'-12-31')::date,
	   (extract(year from '2019-11-01 00:00:00'::date-interval'1 year')::varchar(4)||'-12-31')::date, 
	   (extract(year from '2018-11-01 00:00:00'::date-interval'1 year')::varchar(4)||'-12-31')::date
	  )

    когда нужно ЗАХАРДКОДИТЬ дату

    Запостил: Was666, 17 Февраля 2023

    Комментарии (2) RSS

    Добавить комментарий