All Questions
5 questions
1
vote
1
answer
848
views
How to get time difference between MIN timestamp and MAX timestamp
I'm trying to get the MAX & MIN Timestamp for the certain time frame. As you can see here:
I will use mysql or pl/sql
Is it possible to get it?
Example:
Black block: 11/2/2022 05:45:28 ~ 11/2/...
- 11
-1
votes
1
answer
813
views
how to get min max in timestamp
I have table data and need to get a result set containing a row for the max(timestamp) for id. where timestamp between parameter
The data sample would look like: example data
I can't figure out how ...
0
votes
2
answers
97
views
How do I get a Min and Max from certain ids in sql
I got a database with certain colums I am working with the adress and the time(unixtime) but I need to calculate from all colums with the same record(value) from the colum adres the time between the ...
user7860868
-1
votes
2
answers
154
views
Mysql, timestamp and find extreme values
Is it possible in mysql to find extremes values
I have table with columns (timestamp, value) and I have to detect when values started to increased and decreased and notice that value.
I.e with this ...
3
votes
3
answers
14k
views
MySQL - How to select rows with the min(timestamp) per hour of a given date
I have a table of production readings and need to get a result set containing a row for the min(timestamp) for EACH hour.
The column layout is quite simple:
ID,TIMESTAMP,SOURCE_ID,SOURCE_VALUE
The ...
- 51