LMSouq
moodle-core Open

Get first date from timestamp in SQL

ST
StartVader
1 month ago
3 views
Problem Description
I have in my Moodle `db` `table` for every `session` `sessid` and `timestart`. The table looks like this: +----+--------+------------+ | id | sessid | timestart | +----+--------+------------+ | 1 | 3 | 1456819200 | | 2 | 3 | 1465887600 | | 3 | 3 | 1459839600 | | 4 | 2 | 1457940600 | | 5 | 2 | 1460529000 | +----+--------+------------+ How to get for `every` `session` the `first` `date` from the `timestamps` in `SQL`?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base