On Wed, 4 Jun 2008, Ralph Smith wrote: > date_string := to_date(year||'-'||month||'-'||day , 'YYYY-MM-DD') ; > RAISE INFO 'date_string = %', date_string ; > good_date := to_timestamp(date_string, 'YYYY-MM-DD') ; > RAISE INFO 'good_date = %', good_date ;
This seems like alot of extra work, due to the implicit cast from date to timestamp. I think good_date := to_date(year || '-' || month || '-' || day, 'YYYY-MM-DD') might work and just be simpler. > UsecsD := EXTRACT(EPOCH FROM TIMESTAMP 'good_date') ; If good_date's already a timestamp, I think this should just be: EXTRACT(EPOCH FROM good_date) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
