Re: [sqlite] Should Unary + Cast to a Number?

[David Wheeler]

On Mar 17, 2005, at 2:59 PM, Kurt Welgehausen wrote:
Sorry, I misunderstood the context.
No problem.
sqlite> select * from datetest;
k           d
----------  -------------------
1           2005-03-17T16:21:30
sqlite> select strftime("%m", substr(d,1,10)||' '||substr(d,-8,8))     
            ...> from datetest;
strftime("%m", substr(d,1,10)||' '||substr(d,-8,8))
---------------------------------------------------
03
sqlite> select abs(strftime("%m", substr(d,1,10)||' '||substr(d,-8,8)))
   ...> from datetest;
abs(strftime("%m", substr(d,1,10)||' '||substr(d,-8,8)))
--------------------------------------------------------
Well, I might as well use the substr() function, then:
sqlite> select abs(substr('2005-03-17T16:21:30', 6, 2));
abs(substr('2005-03-17T16:21:30', 6, 2))
----------------------------------------
3
Thanks for the implicit hint about using abs() for casting '03' to 3, 
though.

Regards,
David