timestamp v posgresql

[Jiri Chaloupka]

No, je tam verze 7.1.3, a vraci mi:

PostgreSQL said: ERROR: Bad interval external representation '1003269600'
Your query:
SELECT '1970-1-1'::datetime + (datprod::text)::interval FROM sells where
id = 15294

Pripadne jsem jeste zkusil
PostgreSQL said: ERROR: Bad interval external representation 'datprod'
Your query:
SELECT 'epoch'::timestamp + 'datprod'::interval where id = 15294

Ale to by na teto verzi asi nemelo fungovat ...

Nonecna verze by mela vypadat jeste takto, ale to asi neni podstatne...
PostgreSQL said: ERROR: Bad interval external representation '1003269600'
Your query:
select * from sells where ('1970-1-1'::datetime +
(datprod::text)::interval) > '2002-07-01'

Jirka

-- 
Jiri Chaloupka
B2BExpander.com
chaloupka na b2bexpander.com
**********************************************
Have you visited www.b2bexpander.com today?