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();
Title: RE: [SQL] Problem with timestamp
Beatrice Yueksel wrote:
> Hello,
>
> I try to check the time needed by a function.
> I would like to :
> . select current_timestamp,
> . execute 5000 times a function
> . select the current_timestamp and return the inte
On Thu, 22 Aug 2002, Lucas Brasilino wrote:
> Hi Stephan
>
> >>So, how can I get the same result above without using time() ??
> >>Or if it not possible, how can I extract (yes, I tried with extract()
> >>function too) time from a timestamp column?
> >>I know it's quite simple question..
Hi Stephan
>> So, how can I get the same result above without using time() ??
>>Or if it not possible, how can I extract (yes, I tried with extract()
>>function too) time from a timestamp column?
>> I know it's quite simple question... but I haven't find any clue!
>>
>
> In general you
On Tue, 20 Aug 2002, Lucas Brasilino wrote:
> I'm running postgresql 7.0 with a column like:
>
> Table "materia"
> Column | Type | Modifiers
> +--+---
>
> materiadata| timesta
