Re: CURRENT_TIMESTAMP vs actual time

On Thu, 2005-04-21 at 10:21, Thomas Hallgren wrote:
> Christopher J. Bottaro wrote:
> > Alvaro Herrera wrote:

> > Ahh, thanks for the tip. I guess I'll just stick with
> > timeofday()::timestamp...its more concise anyways...
> >
>
> Why use timeofday() at all? Why not now(). It will return a timestamptz
> without casts.

I think you missed the first part of the conversation, which was he
needed a type that updated inside a transaction:

# begin;

# select timeofday()::timestamptz;
2005-04-21 10:59:58.181834-05

# select now();
2005-04-21 10:59:50.286865-05

# select timeofday()::timestamptz;
2005-04-21 11:00:04.821057-05

# select now();
2005-04-21 10:59:50.286865-05