Joandi - 2010-02-01 03:11:49 - In reply to message 1 from MyNem
yes it is, because i use TEXT as data type on SQLITE to make sure it can work for general purpose... your date stored as TEXT value,
the TEXT data type cannot validate DATE format...
if you want to use it as DATE, then you need to change the data type on SQLITE as DATE, on Create database section, after that you can validate it as DATE format... i recommend it if you store all value as DATE...
in other way you can validate it manually using PHP Function...
example for DATE process:
1. you store '2009-02-01'
2. you get the value using get value function
2. you can use explode();
3. then you can process the array using mktime();
4. after that you can receive UNIX Timestamp ^^