pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Oleg Bartunov <oleg@sai.msu.su>
To: Joel Fradkin <jfradkin@wazagua.com>
Cc: 'Achilleus Mantzios' <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: datediff is there something like it?
Date: Tue, 25 Jan 2005 22:03:21 +0300 (MSK)
Message-ID: <Pine.GSO.4.62.0501252202510.6363@ra.sai.msu.su> (raw)
In-Reply-To: <000201c50306$e9c1b380$797ba8c0@jfradkin>
References: <000201c50306$e9c1b380$797ba8c0@jfradkin>

  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without 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--



view thread (5+ messages)  latest in thread

Message-ID: <Pine.GSO.4.62.0501252202510.6363@ra.sai.msu.su>
Permalink:  ../Pine.GSO.4.62.0501252202510.6363@ra.sai.msu.su/
Also on:    postgresql.org/message-id/Pine.GSO.4.62.0501252202510.6363@ra.sai.msu.su

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: oleg@sai.msu.su, jfradkin@wazagua.com, achill@matrix.gatewaynet.com
  Subject: Re: datediff is there something like it?
  In-Reply-To: <Pine.GSO.4.62.0501252202510.6363@ra.sai.msu.su>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox