All Questions
3 questions
1
vote
0
answers
407
views
Resample time series in SQLite
I have following table:
CREATE TABLE entries (
utc TEXT,
entry INTEGER
);
with following data:
INSERT INTO entries
(utc, entry)
VALUES
('2022-10-01 01:54', 23),
('2022-10-04 02:40', 46),
(...
- 113
0
votes
1
answer
50
views
WITH-clause not pre-calculated, lineal resource wasting, why?
I'm trying to save resources, and shorten code, but getting lineal resource wasting with "WITH-clause".
This is my base example:
#!/bin/bash
echo "CREATE TABLE 'clients_table' ( id ...
- 18
1
vote
1
answer
64
views
Order By with duration strings having time units
I have a SQLite database with a table "Rate" who has a column "timeToMaturity". This column contains strings such as :
7Months
26Days
3Years
I'd like to order a query results by timeToMaturity (i.e. ...
- 127