Monthly Archives: October 2011

how to retrieve date from a different timezone

SELECT id, name, creation_date AT TIME ZONE ‘PST’ FROM account ORDER BY creation_date DESC LIMIT 25; Advertisements

Posted in Uncategorized | Leave a comment

how to handle xml data with regexp_replace

update table set xmlcol = xmlparse(document regexp_replace(xmlserialize(document xmlcol as text), ‘***= +| idea …rest of string here…’, ”)) where id=whatever;

Posted in Uncategorized | Leave a comment