What are the pros and cons of storing a DateTime a...

# android

[AmrJyniat]

What are the pros and cons of storing a DateTime as a timestamp in Room DB? is it good practice? because I heard that will lose control of timeZone if do so, how do you handle this process guys?

[hfhbd]

Just store the ISO-8601 string from Instant

[Mihail Ya]

Storing string representation of date can impact on queries where you want to compare dates (eg: it will be impossible to select rows where the date column is between two dates)

[hfhbd]

ISO8601 is sorted, so filtering/comparing is possible