SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE design_exported ( event_id TEXT, timestamp BIGINT , user_id TEXT, design_category TEXT ); INSERT INTO design_exported (event_id, timestamp, user_id, design_category) VALUES ('a',1625731913,'z','animals'), ('b',1557866863,'y','animals'), ('c',1557866863,'x','plants'), ('c',1557866863,'x','plants'), ('c',1557866863,'a','plants'), ('e',1557866863,'b','plants'), ('g',1557866863,'c','plants'), ('g',1557866863,'d','plants'), ('h',1557866863,'e','plants'), ('i',1557866863,'f','plants'), ('j',1557866863,'g','plants'), ('r',1625731913,'g','potato'), ('e',1625731913,'x','potato') ; ;SELECT EXTRACT(DAY FROM TIMESTAMP) from design_exported
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear