Search Postgresql Archives

Re: is in postgres solution

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, May 16, 2005 at 11:43:09 +0300,
  Margus Roo <margusja@xxxxxxx> wrote:
> Hello.
> I have 2 variables type timestamp. Example date1 = 2005-01-01 23:00 and 
> date2 = 2005-05-04 12:00. I want get something like age(date2,date1) but 
> ouput format must by hours::minutes.
> 
> Is that bossible?

extract the epoch from the difference in timestamps and that will give
you a time in seconds that you can format as desired with a little
math.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux