Project translated automatically. Log in or register, to view the original Create a request from one table on a temporary range. There is a table_a, in which column c is named m_d type timestamp. You need to select all the records from the table for the last 14 hours from the current time, resulting in the number of records.

Proposals 1 Discussions 5

Yury Surzhikov

Winning proposal

5 0

Projects 5
Rating -
Rating 182

Budget: 500 RUB Deadline: 1 day

I will easily do your job. I have experience with PostgreSQL for more than six months. For more details, please write to a person or telegram: yuriy_su

Andrey Rudnev

12 December 2019

Сейчас сможете сделать ?

Sergey Morlang 13 December 2019

Вроде так

SELECT * FROM [DB_NAME] WHERE (((now() - interval '14:00:00')::timestamp with time zone) <= m_d);

Sergey Morlang 13 December 2019

Если только кол-во то:
SELECT COUNT(*) FROM test WHERE (((now() - interval '14:00:00')::timestamp with time zone) <= m_d);

Andrey Rudnev

13 December 2019

спасибо за ответ, быстрее всего отрабатывает с использованием current_timestamp

Sergey Morlang 13 December 2019

Спасибо

Add Comment

Current freelance projects in the category Databases & SQL

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 17 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 19 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 42 proposals 27 July

179 USD
Client registration and visit confirmation system (MVP)

Web Programming 162 proposals 10 July

Not specified

Andrey Rudnev
Saint-Petersburg, Russia

Projects 1
Rating -
Rating 72

Yury Surzhikov

Yury Surzhikov

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client registration and visit confirmation system (MVP)