> On Sep 13, 2015, at 3:53 PM, E.Pasma <pasma10 at concepts.nl> wrote: > > I just learned that the strftime function returns '0' for Sundays, not 0, and > that 0<>'0?.
Yes, always compare likes to likes:
with
DataSet
as
(
select strftime( '%w', date() ) as value
)
select value,
typeof( value ) as typeof1,
cast( value as interger ) as integer,
typeof( cast( value as interger ) ) as typeof2
from DataSet
> value|typeof1|integer|typeof2
> 0|text|0|integer
