Stephan Szabo <[EMAIL PROTECTED]> writes:
> I think select CAST(CURRENT_TIMESTAMP(0) AS timestamp without time zone)
> may get you what you want without having to rely on the text format.
If you don't want the time zone, there's also LOCALTIMESTAMP(n). See
http://www.postgresql.org/docs/7.3/stati
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
>
>
"Kumar" <[EMAIL PROTECTED]> writes:
> I wanted to update one column of my table with now() or timestamp. And I wa=
> nt that timestamp of format
> 2003-09-19 18:39:08.13
It sounds like you simply want to limit the fractional precision of the
value. Why don't you just dec
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_TIMEST
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
To achieve this I have used the following
wats=# select now();
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
To achieve this I have used the following
wats=# select
now();
