timestamp v posgresql
Jiri Chaloupka
dev na b2bexpander.com
Čtvrtek Červenec 18 13:30:50 CEST 2002
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?
Další informace o konferenci Test