tag:blogger.com,1999:blog-9053536529694784563.post6540158261434380575..comments2020-05-07T00:33:57.272-07:00Comments on Database Explorer: 3.14159265358979Simon Riggshttp://www.blogger.com/profile/06017750505968534813noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9053536529694784563.post-14642298876188557642010-03-15T04:06:59.490-07:002010-03-15T04:06:59.490-07:00Some more fun:
=# select to_date('2010.' ...Some more fun:<br /><br />=# select to_date('2010.' || pi()::text, 'YYYY.MM.DD');<br /> to_date <br />------------<br /> 2010-03-14<br />(1 row)<br /><br /><br />=# select to_timestamp('2010.' || pi()::text, 'YYYY.MM.DDSSSSUS');<br /> to_timestamp <br />-------------------------------<br /> 2010-03-14 04:25:26.535897+01<br />(1 row)dimhttp://tapoueh.orgnoreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-54777975764335472172010-03-14T20:12:33.297-07:002010-03-14T20:12:33.297-07:00it works better like this:
# select ln(exp(1::num...it works better like this:<br /><br /># select ln(exp(1::numeric));<br /> ln <br />--------------------<br /> 1.0000000000000000<br />(1 row)Anonymousnoreply@blogger.com