truedat101

SMILE Plug is running:
Linux SMILEplug 2.6.35.9-ARCH #7 PREEMPT Wed Sep 19 14:07:47 MDT 2012 armv7l GNU/Linux
root@SMILEplug:~/spdist# cat /proc/cpuinfo 
Processor	: Marvell PJ4Bv7 Processor�� rev 1 (v7l)
BogoMIPS	: 1199.30
Features	: swp half thumb fastmult vfp edsp vfpv3 vfpv3d16 
CPU implementer	: 0x56
CPU architecture: 7
CPU variant	: 0x1
CPU part	: 0x581

truedat101

/* Simple query to convert dob (date) into number) */
SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl

/* Simple query to add WHERE clause into above computed field, get all aged above 50 */
select age from (SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl) bar where age > 50;

/* Simple query to add WHERE clause into above computed field, get all aged above 25 and less than 70 */
select age from (SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl) bar 
WHERE age > 25 
AND age < 70

truedat101

# .gitignore for IDE users


#
# .gitignore for eclipse
# 
.settings

#
# .gitignore for XCode users