[sqlite] Date comparison on UTC

[Andre du Plessis]

I have a UTC date stored in text column in this format:

 

2007-08-27 08:58:16.601000

 

I want to do some selects for all that is newer than one day for
example, or then all that is older than 1 month, etc,

 

Any ideas?

 

Thanks.