i have developed a pgplsql function to receive array of dates the return the maximum date, but its not able to call the function: select 1, arcfm.array_max_date('{2022-02-03, 2022-06-05}'::timestamp[]) as max_date_time; CREATE OR REPLACE FUNCTION arcfm.array_max_date(in dates_array timestamp[]) RETURNS timestamp LANGUAGE…
In PostgreSQL 11, I am trying to get a weekend time range. From 17:00 Friday to Sunday 17:00. So far I am able to get a working day by doing select * from generate_series(date '2021-01-01',date '2021-12-31',interval '1' day) as t(dt)…
i have an Array with this string value. [VALIDUNTIL] => 28.08.23 Now i need to compare it with the todays date and check if the VALIDUNTIL date is in the same month and year as the today´s date i looked…
I have data with a frequency of one minute for 3 years and I would need to put it in one table to make it comparable. Table1-2019 date_time v_2020 01.01.2019 01:00:00 50 01.01.2019 01:01:00 49 01.01.2019 01:02:00 56 Table2-2020 date_time…
I have a DATETIME column in a MySQL database. I use ResultSet metadata to retrieve the column type and it returns TIMESTAMP which is incorrect. How can I get the correct java.sql.SQLType value for this column? I will try to…
I use OpenAI's Whisper python lib for speech recognition. How can I get word-level timestamps? To transcribe with OpenAI's Whisper (tested on Ubuntu 20.04 x64 LTS with an Nvidia GeForce RTX 3090): conda create -y --name whisperpy39 python==3.9 conda activate…
I'm using mysql. I have two tables, one is about movie type, and the other is about movie rating with timestamps. I want to join these two tables together with movie id to count the average rating for each type…
I have a column named 'CreatedAt' in postgres (DBeaver client) that is an int8 datatype and holds a unix timestamp value. Example: 1659347651689 I am writing a query that I'd like to input an ISO datet ime in the where…
Is there any convention to add in a local timezone (whatever the user has set it as) in a database? For example, like I can do the following for UTC time: 2014-01-01 01:02:03Z Is there something like the following to…
All I want to do is set a Firebase Server Timestamp in setData() but I can't seem to figure out how to get it to work. Here is what I've tried: for document in snapshot!.documents { do { try document.reference.collection("Data").document()…