Question: I am trying to count events that happen in a day, which in itself is easy:

```
SELECT date(time),COUNT(DISTINCT comment)
FROM data
GROUP BY date(time)

```

But I need a day end to be set at 4pm. So all comments before 4pm is day N, and news after 4pm are day N+1. This isnt a global thing, so I'd rather not change time zone of entire program and etc. Maybe I can somehow apply timezone to this query or pad time?

Answer: 
If you have a string like this: '123456'
and you want a list of integers like this: [1,2,3,4,5,6], use this:

```
>>>s = '123456'    
>>>list1 = [int(i) for i in list(s)]
>>>print(list1)

[1,2,3,4,5,6]

```

or if you want a list of strings like this: ['1','2','3','4','5','6'], use this:

```
>>>s = '123456'    
>>>list1 = list(s)
>>>print(list1)

['1','2','3','4','5','6']

```
```
num = list(str(100))
index = len(num)
while index > 0:
    index -= 1
    num[index] = int(num[index])
print(num)

```

It prints `[1, 0, 0]` object.