Question

如何从现在起 minu到 s底再 second?

和:

页: 1

Answer 1

这里有一条路:

DROP TABLE IF EXISTS a_table;
CREATE TABLE IF NOT EXISTS a_table (time TEXT DEFAULT CUURENT_TIMESTAMP);
WITH counter(x) AS (SELECT 1 UNION ALL SELECT x + 1 FROM counter LIMIT 10)
INSERT INTO a_table SELECT datetime( now ,(random() % 1234)||  seconds ) FROM counter;

/* The query (see the expression used for the `roundedTime` column) */
SELECT *,
    datetime(
        time,
         - ||strftime( %M ,time)||  minutes ,
         - ||strftime( %S ,time)||  seconds 
    ) AS roundedTime,
    strftime( %M ,time) AS mins,
    strftime( %S ,time) AS secs
FROM a_table;
DROP TABLE IF EXISTS a_table;

When run the output will be something along the lines of:-

note that data is based upon the date and time when run and that a 0 - 1233 seconds adjustment will made to each row. So every run will yield different results (probably typically with the same hour change 1234 to a larger number 3600 for up to an hours variance). The number of rows inserted as controlled by the LIMIT (10)

友情链接