Skip site navigation (1) Skip section navigation (2)

Re: timestamp/function question

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Soma Interesting <dfunct(at)telus(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp/function question
Date: 2001-03-29 17:41:08
Message-ID: 20010329.17410800@ler-freebie.iadfw.net (view raw or flat)
Thread:
Lists: pgsql-general
On the documentation problems, patches are gratefully accepted.  As you 
learn more and see problems with the docs, we'd love to get patches. 

Larry Rosenman

-- 
Larry Rosenman                             http://www.lerctr.org/~ler/
Phone: +1 972 414 9812                          E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 US

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 3/29/01, 11:07:17 AM, Soma Interesting <dfunct(at)telus(dot)net> wrote 
regarding Re: [GENERAL] timestamp/function question :


> At 10:56 AM 3/29/2001 -0500, you wrote:
> >Because you asked for a value based on the current *date*.
> >If you waited till tomorrow and tried again, then you'd get a
> >different answer.  Perhaps you want
> >
> >                 RETURN date_part(''epoch'', CURRENT_TIMESTAMP);

> Thank you Tom!

> Thank-you! Thank-you! Thank-you! Thank-you!

> How can I possibly thank you enough?! I want you to know how much I
> appreciate your answers because I'll have more questions for you one 
day...

> I love postgres, but I hate your documentation... (that doesn't mean I
> don't read it however).


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

In response to

Responses

pgsql-general by date

Next:From: Soma InterestingDate: 2001-03-29 17:44:20
Subject: Re: timestamp/function question
Previous:From: Mitch VincentDate: 2001-03-29 17:25:06
Subject: Re: tables, where

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group