Size: a a a
OK
WHERE to_char(birthday, 'MM-DD') = '02-05'
SB
WHERE to_char(birthday, 'MM-DD') = '02-05'
МШ
WHERE to_char(birthday, 'MM-DD') = '02-05'
WHERE birthday = '02-05'::date синтаксис наверняка ошибочный, но идея, я думаю, понятна.OK
AN
SB
AY
WHERE to_char(birthday, 'MM-DD') = '02-05'
SELECT substring(birthday::date::TEXT, 6, 6)
OK
SELECT substring(birthday::date::TEXT, 6, 6)
МШ
WHERE to_char(birthday, 'MM-DD') = '02-05'
OK
am
concat(lpad(cast(extract(month from birthday) as text), 2, '0'), '-', lpad(cast(extract(day from birthday) as text), 2, '0'))
OK
RY
AY
WITH D as (
SELECT '19860201'::date AS birthday
)
SELECT
DATE_PART('year', AGE(NOW(), birthday)) AS years,
birthday + DATE_PART('year', AGE(NOW(), birthday)) * '1 year'::INTERVAL AS mmdd,
(NOW() - (birthday + DATE_PART('year', AGE(NOW(), birthday)) * '1 year'::INTERVAL)) BETWEEN '-30 day'::INTERVAL AND '30 day'::Interval
FROM D
am
WITH D as (
SELECT '19860201'::date AS birthday
)
SELECT
DATE_PART('year', AGE(NOW(), birthday)) AS years,
birthday + DATE_PART('year', AGE(NOW(), birthday)) * '1 year'::INTERVAL AS mmdd,
(NOW() - (birthday + DATE_PART('year', AGE(NOW(), birthday)) * '1 year'::INTERVAL)) BETWEEN '-30 day'::INTERVAL AND '30 day'::Interval
FROM D
am
RY
AY
VK
am
ssh -L 65432:localhost:5432 remote_user@remote_host и посмотрите, отвечает ли порт.