Re: datediff is there something like it? - Mailing list pgsql-sql
| From | Oleg Bartunov |
|---|---|
| Subject | Re: datediff is there something like it? |
| Date | |
| Msg-id | Pine.GSO.4.62.0501252202510.6363@ra.sai.msu.su Whole thread Raw |
| In response to | Re: datediff is there something like it? ("Joel Fradkin" <jfradkin@wazagua.com>) |
| List | pgsql-sql |
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadablewithout MIME-aware tools. ---559023410-912437380-1106679801=:6363 Content-Type: TEXT/PLAIN; charset=koi8-r; format=flowed Content-Transfer-Encoding: 8BIT On Tue, 25 Jan 2005, Joel Fradkin wrote: > Yes I am using datepart, but not seeing how with a datediff. > Maybe I just need to do the date math and put a date part on the result. > I will play around a bit when I hit one not looking for days. > http://www.pgsql.ru/db/pgsearch/index.html?q=datediff > Joel Fradkin > > Wazagua, Inc. > 2520 Trailmate Dr > Sarasota, Florida 34243 > Tel. 941-753-7111 ext 305 > > jfradkin@wazagua.com > www.wazagua.com > Powered by Wazagua > Providing you with the latest Web-based technology & advanced tools. > © 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc > This email message is for the use of the intended recipient(s) and may > contain confidential and privileged information. Any unauthorized review, > use, disclosure or distribution is prohibited. If you are not the intended > recipient, please contact the sender by reply email and delete and destroy > all copies of the original message, including attachments. > > > > > -----Original Message----- > From: Achilleus Mantzios [mailto:achill@matrix.gatewaynet.com] > Sent: Tuesday, January 25, 2005 11:34 AM > To: Joel Fradkin > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] datediff is there something like it? > > O Joel Fradkin ?????? ???? Jan 25, 2005 : > >> Hi all working my way through our views and all is going very well. >> >> We use datediff in MSSQL a bit and I read about the field1::date - >> field2::date to return the days numerically. >> >> Is there any way to get months and years besides guessing days / 30 for >> months etc? > > Go to > http://www.postgresql.org/docs/7.4/interactive/functions-datetime.html > Check out smth like... > > SELECT 'Achilleus is ' || date_part('years',age(timestamp '1969-01-31')) > || ' years and ' || date_part('months',age(timestamp '1969-01-31')) || ' > months old'; > ?column? > ----------------------------------------- > Achilleus is 35 years and 11 months old > (1 row) > > > >> >> >> >> Joel Fradkin >> >> >> >> Wazagua, Inc. >> 2520 Trailmate Dr >> Sarasota, Florida 34243 >> Tel. 941-753-7111 ext 305 >> >> >> >> jfradkin@wazagua.com >> www.wazagua.com >> Powered by Wazagua >> Providing you with the latest Web-based technology & advanced tools. >> C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc >> This email message is for the use of the intended recipient(s) and may >> contain confidential and privileged information. Any unauthorized review, >> use, disclosure or distribution is prohibited. If you are not the > intended >> recipient, please contact the sender by reply email and delete and destroy >> all copies of the original message, including attachments. >> >> >> >> >> >> >> >> >> > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---559023410-912437380-1106679801=:6363--