Subject: | Hello, actualy by using this class... |
Summary: | Package rating comment |
Messages: | 3 |
Author: | MyNem |
Date: | 2009-12-10 10:44:00 |
Update: | 2010-02-01 03:22:56 |
|
|
|
MyNem rated this package as follows:
Utility: | Not sure |
Consistency: | Not sure |
Examples: | Sufficient |
|
 MyNem - 2009-12-10 10:44:00
Hello, actualy by using this class the date-field will not validate correct!
I trying your example and the result is not correct.
maybe i using it wrong? thx for reply
 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:
strtotime();
mktime();
date();
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 ^^
 Joandi - 2010-02-01 03:22:56 - In reply to message 2 from Joandi
sorry i replied on wrong windows...
|