time Archives - DbaFix

Join 2 tables by closest time, PostgreSQL 9.6

By adminPosted on May 10, 2023

Question : I have 2 tables: tbl1, tbl2. CREATE TABLE tbl1(time_1) AS VALUES ( ‘2017-09-06 15:26:03’::timestamp ), ( ‘2017-09-06 15:26:02’ […]

By adminPosted on April 6, 2023

Question : I am developing a service that relies on users being able to recieve messages that they themselves choose. […]

By adminPosted on March 25, 2023

Question : I need to add the date part of GetDate() to the time part of a stored DateTime. Naively […]

By adminPosted on March 11, 2023

Question : My purpose is to monitor which tags increase/decrease rapidly last week on different bulletin boards. Or which tag […]

By adminPosted on March 4, 2023

Question : I’m trying to calculate the elapsed time of Oracle Database startup command. The view V$INSTANCE contains the STARTUP_TIME […]

By adminPosted on February 19, 2023

Question : Environment: I have ‘duration’ datas stored as varchar(4) in a table. 2 first characters are hours, 2 last […]

By adminPosted on February 17, 2023

Question : I want to create a simple function in Postgres to find the difference between 2 TIME – not […]

By adminPosted on February 17, 2023

Question : Does interval ‘1 month’ incorporate month differences and leap years when calculating date/datetime boundaries? If so, how does […]

By adminPosted on January 9, 2023

Question : This has come up a couple of times, e.g., in the postgresql newsgroup and the wiki. In general, […]

By adminPosted on December 26, 2022

Question : I have two machines and each machine has a SQL Server instance. Between these machines I run service […]