Re: [GENERAL] Date & Time

no, you won't ;-)
further testing indicates that current_stamp like current, instead of
now/now().

also, I remembered (I tried to check the archive, but failed) now() should
not be use in where clause, cos it will hurt performance.

Kai

On Wed, 1 Dec 1999, Bruce Momjian wrote:

> > Ed Loehr ha scritto:
> >
> > > Just curious:  anyone have any comment on any practical differences between now() and CURRENT_TIMESTAMP, which
seemsto work 
> > > the same?
> > >
> >
> > I think it is the same function, both of them return the current date and time.
> >
> > now() should be the internal postgreSQL function.
> > and CURRENT_TIMESTAMP is the exact SQL-92 syntax
>
> I am changing my book to use CURRENT_TIMESTAMP rather than now().
>
> --
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
> ************
>