type casting reference?
От | stig erikson |
---|---|
Тема | type casting reference? |
Дата | |
Msg-id | d8i30k$25ij$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: type casting reference? SOLVED
Re: type casting reference? |
Список | pgsql-docs |
hi. i need to cast from timestamp to seconds (in the form of integer). i have a table with a column: expiretime timestamp i have tried the following, it gives errors as below: SELECT expiretime::float4 AS timeleft FROM table WHERE something='1234'; ERROR: cannot cast type timestamp without time zone to real SELECT expiretime::text::float4 AS timeleft FROM table WHERE something='1234'; ERROR: invalid input syntax for type real: "2005-06-12 21:21:24.368082" postgresql 7.4.1 (i know, old) so, my question is simply, where in the docs can i find how i should perform the cast? it would help a lot if there was a table showing which types can be cased into which, and possibly an example or two for situations like this, casting from timestamp (to timestamp worked right away). /stig
В списке pgsql-docs по дате отправления: