tag:blogger.com,1999:blog-4394562672296169849.post2409113676992936858..comments2023-12-21T18:06:15.136+08:00Comments on class Programmer : IEnableMuch {: Add days to timestampIEnableMuchhttp://www.blogger.com/profile/01393635235961303977noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4394562672296169849.post-54919478278011588212011-09-24T14:02:18.336+08:002011-09-24T14:02:18.336+08:00This blog post's context is from stackoverflow...This blog post's context is from stackoverflow, it's a response to an stackoverflow question http://stackoverflow.com/questions/838478/adding-sum-of-current-timestamp-and-days-column-in-postgres<br /><br /><br />"I want update a column by adding days to current time. In pseudosyntax it would be:<br /><br />UPDATE foo<br />SET time = current_timestamp + days::integer;<br /><br /><br />days is a column in the same table."<br /><br /><br />I dwell too much on the poster's question, i.e. adding an integer directly to a date would automatically add days to it. I forgot it's more elegant to do like what you've said, i.e. I should have given him this answer:<br /><br /><br />create table foo<br />(<br />time timestamp,<br />days int<br />);<br /><br />insert into foo values(null, 7);<br /><br />update foo set time = now() + days * interval '1 day';<br /><br /><br />Thanks for noticing that, will advise other Postgres users to use the built-in interval insteadIEnableMuchhttps://www.blogger.com/profile/01393635235961303977noreply@blogger.comtag:blogger.com,1999:blog-4394562672296169849.post-37402069691494689842011-09-19T06:51:44.828+08:002011-09-19T06:51:44.828+08:00Why is that better than "select now() + inter...Why is that better than "select now() + interval '7' day"Nigel Thornehttps://www.blogger.com/profile/07280667421574609074noreply@blogger.com