Hy, i want to split the time to 2 columns by Event type.
My Table looks like this:
User
EventType
Time
name1
Logon
14.08.2022 23:51:12
name2
Logoff
12.08.2022 09:12:44
name2
Logon
11.08.2022 23:51:01
name1
Logoff
16.08.2022 08:27:55
And i want to split the Time with EventType like this in SQLite:
User
Logon
Logoff
name1
14.08.2022 23:51:12
16.08.2022 08:27:55
name2
11.08.2022 23:51:01
12.08.2022 09:12:44
any ideas?
