[Cialug] SQL wizardry possible?

[Claus]

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';
> 
> http://www.postgresql.org/docs/8.2/interactive/functions-string.html
> http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html
> 
> Jeff


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.