[Cialug] SQL wizardry possible?
cniesen at gmx.net
Tue Oct 30 16:59:12 CDT 2007
On 10/30/2007 4:40 PM, Jeffrey C. Ollie wrote:
> Completely untested, but:
> select pref_uid,pref_value from horde_prefs where pref_name = 'last_login' and age(to_timestamp(to_number(substring(pref_value from 'i:([0-9]+);'))) < interval '6 months';
FYI: "substr" are supported by DB2 and Oracle (it's probably part of
SQL). I'm not sure about substring and other weird things that have
been suggested so far. Of course assuming the embedded time stamp is
always at the same position. Otherwise you are screwed trying to do
anything SQL compliant.
More information about the Cialug