Re: Problem with timestamp - Pls help - Mailing list pgsql-sql

On Fri, 19 Sep 2003, Stephan Szabo wrote:

> On Fri, 19 Sep 2003, Kumar wrote:
>
> > Dear Friends,
> >
> > I am using Postgres 7.3.4 on Linux server 7.3.
> >
> > I wanted to update one column of my table with now() or timestamp. And I want that timestamp of format
------------------------
>
> >  2003-09-19 18:39:08.13
>
> I think select CAST(CURRENT_TIMESTAMP(0) AS timestamp without time zone)

I meant (2) above.