python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - timestamp

SQL query duration as consecutive timestamps difference, grouped by day

Basically, I have a table like this id timestamp state minutes 1 7/12/2021, 17:38 off 14.54 1 7/12/2021, 17:53 running 8.39 1 7/12/2021, 18:01 off 8.12 1 9/12/2021, 00:04 running big val...
test-img

Kunis

sql

postgresql

datetime

timestamp

Votes: 0

Answers: 1

Latest Answer

Something like this: with Cal as ( select cast(DayStarts as date) as Date, DayStarts, DayStarts + interval '1 day' - interval '1 second' as DayEnds from ( select CAST('2021-12-07' AS time...
test-img

tinazmu

send email from currently logged in user when checkbox is TRUE

My question is an extension of this fantastic solution but am hoping to take it one step further. Whenever a user other than me marks the checkbox as TRUE, the sender of the email is always me, since...
test-img

Nate

email

google-apps-script

google-sheets

triggers

timestamp

Votes: 0

Answers: 1

Latest Answer

From the question Is it possible to capture the user currently logged in and make them the sender? If you are using a free Google account (usually gmail.com account) it might be possible if you use ...
test-img

Rubén

Python: take unique dates in dataframe

I have a data frame that looks like this: price Date 2022-01-01 19:20:00 100 2022-01-01 19:27:00 100 2022-01-02 19:31:00 102 I want the dataframe to only have uniqu...
test-img

MathMan 99

python

pandas

dataframe

datetime

timestamp

Votes: 0

Answers: 2

Latest Answer

You can simply use duplicated: # pre-requisite df['Date'] = pd.to_datetime(df['Date']) df[~df['Date'].dt.date.duplicated()] Or if working with the index: df[~df.index.to_series().dt.date.duplicated(...
test-img

mozway

Get distinct values within time chunks

I have a table with different species and their occurences (timestamp) from field survey: species | timestamp A | 2021-04-01T12:35 A | 2021-04-01T12:36 B | 2021-04-01T12:36 A |...
test-img

EndorCartographer

sql

sqlite

timestamp

distinct

timespan

Votes: 0

Answers: 1

Latest Answer

Use datetime function strftime() to produce the chunks: SELECT DISTINCT strftime( '%Y-%m-%dT%H:%M', timestamp, '-' || CASE WHEN timestamp LIKE '%0' THEN 9 ELSE SUBS...
test-img

forpas

Posts

Questions

Blogs

Jobs