On 2012-02-09, Edward W. Rouse wrote:
>> the operation abs() is meaninless on the type interval
>> eg: what is abs( '1 month - 32 days + 24 hours'::interval )
>
> If you need to add 30 intervals together, then +- is not meaningless.
if you stop reading after one line you miss the answer.
--
> -Original Message-
> From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-
> ow...@postgresql.org] On Behalf Of Jasen Betts
> Sent: Thursday, February 09, 2012 6:37 AM
> To: pgsql-sql@postgresql.org
> Subject: Re: [SQL] time interval math
>
> On 2012-02-08
On 2012-02-08, Edward W. Rouse wrote:
> I'm still working on getting this to work, but the summary is this:
>
> I am getting several (many) intervals of hour, minutes and seconds. I need a
> sum of the absolute value these intervals, similar to the SUM(ABS())
> function for numbers; and I need to
"Edward W. Rouse" wrote:
> Hehe, thanks, I played around and ended up with this:
> round(SUM(extract('epoch' from (time_out - time_in
> I will have to do the division outside of the query, but that's really a
> minor issue.
You can always use subqueries.
> Knowing the total i
3600 + ":" + a / 60 + ":" + a % 60)
> -Original Message-
> From: Steve Crawford [mailto:scrawf...@pinpointresearch.com]
> Sent: Wednesday, February 08, 2012 3:26 PM
> To: Edward W. Rouse
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] time inter
On 02/08/2012 12:01 PM, Edward W. Rouse wrote:
I'm still working on getting this to work, but the summary is this:
I am getting several (many) intervals of hour, minutes and seconds. I need a
sum of the absolute value these intervals, similar to the SUM(ABS())
function for numbers; and I need to
On 3/6/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Hi list,
It is possible to retrieve the time of a SQL statement leads to
execute ? I would like to put in my application how much time each
operation leads to finish.
Any suggestion ?
--
Ezequias Rodrigues da Rocha
http://ezequi
On 3/6/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Hi list,
It is possible to retrieve the time of a SQL statement leads to
execute ? I would like to put in my application how much time each
operation leads to finish.
Any suggestion ?
--
Ezequias Rodrigues da Rocha
http://ezequi
EXPLAIN ANALYZE does give the query execution time at the end of its output.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/6/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
EXPLAIN ANALYZE Is perfect but i have no idea of how to use it. My
resultset is retrieving my rows.
EXPLAIN ANALYZE is only for tuning purposes.
Read the manual
(http://www.postgresql.org/docs/8.1/interactive/sql-explain.html) to get more
insight
>>> "Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 2007-03-06 14:55 >>>
EXPLAIN ANALYZE Is perfect but i have no idea of how to use it. My
results
EXPLAIN ANALYZE Is perfect but i have no idea of how to use it. My
resultset is retrieving my rows.
Another question that cames with the Analyze. PgAdmin return the time
to retrieve the data or all time to fill the grid on the "SQL Editor".
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blo
Assuming you're using stored procedures...
Start procedure with logging current time, name of procedure,...
Perform whatever must be performed
End procedure with logging current time, name of procedure,...
Query logging table to get time spent
Alternative, still assuming you're using stored proce
Did you try EXPLAIN ANALYZE ?
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/6/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
I preffer that the database give me this information. I don't know if
it is possible becouse if we retrieve many rows and if we want to put
this re
I preffer that the database give me this information. I don't know if
it is possible becouse if we retrieve many rows and if we want to put
this result in a new column the same time will be replicated many
times and consuming more processing.
Any other suggestion ?
Ezequias
2007/3/6, Bart Degrys
note the time just before your operation starts
note the time just after it ends
show timeafter - timebefore
>>> "Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 2007-03-06 14:20 >>>
Hi list,
It is possible to retrieve the time of a SQL statement leads to
execute ? I would like to put in my appl
"A. R. Van Hook" <[EMAIL PROTECTED]> writes:
> How does one sum interval sums?
> the following does not work:
> select sum(stop-start::interval) as total from startstop
Define "does not work"? What did you get, what were you hoping for?
Personally I'd drop the unnecessary cast, but AFAICS there
On Thu, Nov 10, 2005 at 08:29:07PM +0100, Tadej Kanizar wrote:
> I have a table with a column of type TIMESTAMP.
> In output, I need to format it.. what's the best way to do it?
> So, for instance, how could I format it so that it would output as YY-MM-DD
> HH:MM?
See to_char() in the "Data Type F
PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Tom Lane
Sent: 10. november 2005 20:14
To: Michael Fuhr
Cc: Rod Taylor; Judith Altamirano Figueroa; pgsql-sql@postgresql.org
Subject: Re: [SQL] time
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Am I missing something? Is there a reason not
On Thu, Nov 10, 2005 at 02:13:43PM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > Am I missing something? Is there a reason not to simply cast the
> > timestamp value to time?
>
> I think the OP was trying to use the functional cast syntax
> time(now())
> which worked
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Am I missing something? Is there a reason not to simply cast the
> timestamp value to time?
> test=> select now()::time;
>now
> -
> 11:19:19.892125
> (1 row)
> test=> select cast(now() as time);
>now
>
[Please copy the mailing list on replies.]
On Thu, Nov 10, 2005 at 12:24:17PM -0600, Judith Altamirano Figueroa wrote:
> excuse me and how can I just get the hour, minute and second
The time type takes an optional precision:
test=> select now()::time;
now
-
11:36:3
On Thu, 2005-11-10 at 11:21 -0700, Michael Fuhr wrote:
> On Thu, Nov 10, 2005 at 01:11:27PM -0500, Rod Taylor wrote:
> > rbt=# select cast(now() - date_trunc('day', now()) as time);
> > time
> > -
> > 13:10:42.495579
> > (1 row)
>
> Am I missing something? Is there a reason
On Thu, Nov 10, 2005 at 01:11:27PM -0500, Rod Taylor wrote:
> rbt=# select cast(now() - date_trunc('day', now()) as time);
> time
> -
> 13:10:42.495579
> (1 row)
Am I missing something? Is there a reason not to simply cast the
timestamp value to time?
test=> select cast(no
On Thu, 2005-11-10 at 09:03 -0600, Judith Altamirano Figueroa wrote:
> Hello everybody!!!, I'd like to know if there another way to get the
> time from a timestamp type, because in earliest versions I just get
> the time like time(fecha) and now this returns an error, thanks in
> advanced!!!
r
Hello everybody!!!, I'd like to know if there another way to get the time from a timestamp type, because in earliest versions I just get the time like time(fecha) and now
this returns an error, thanks in advanced!!!
To: Anthony Molinaro; pgsql-sql@postgresql.org
Subject: RE: [SQL] Time differences between rows, not columns?
Importance: High
Thanks!
Amit,You say "I want to know how much time it took for a bill to
be accepted after it was submitted" So, do you want between 10 and 40,
not 10 and 20
query? Or the max()
query?
Thanks a lot for your time!
Regards,
Amit
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Molinaro
Sent: Tuesday, August 30, 2005 4:59 PM
To: Wadhwa, Amit; pgsql-sql@postgresql.org
Subject: Re: [SQL] Time differences
Amit,
You say "I want to know how much time it took for a bill to be
accepted after it was submitted"
So, do you want between 10 and 40, not 10 and 20?
I assume you meant 10 and 40.
Ok, there's a few approaches to your questions, first
To get "how much time it took for a bill to be accepted afte
On Wed, 20 Oct 2004, Markus Bertheau wrote:
> http://www.postgresql.org/docs/current/static/sql-createtable.html says,
> down at the explanation of DEFERRABLE, that constraints are checked
> after every command. Why does the following not work then:
>
> CREATE TABLE foo (
> pos INT UNIQUE
> );
Ð ÐÑÐ, 20.10.2004, Ð 17:58, Markus Bertheau ÐÐÑÐÑ:
> I also noticed, that the docs don't state whether INITIALLY IMMEDIATE or
> INITIALLY DEFERRED is the default.
I just overlooked that, sorry, it is stated.
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)-
"Raman Garg" <[EMAIL PROTECTED]> writes:
> Actually my "between" is creating some problems and is not giving me results
> so what I have done is . IN MY WHERE CLAUSE OF QUERY:
I suspect that this revised clause will give you problems too, namely
selecting rows you don't want.
I think what may act
On Thursday 05 February 2004 14:59, Raman Garg wrote:
> Hi Richard,
>
> What I am having is
>
> CREATE TABLE "customer_events" (
> "event_id" numeric (10) NOT NULL,
> "customer_id" numeric (10) NOT NULL,
> "event_name" varchar (100) ,
> "event_datetime" date ,
> "start_time" time ,
> "repeat_untill
one(-7:00)
Well, it worked for me now.. maybe some logic of neagative time zone is
there due to which our time calculation make the difference of two time
greater. :-?
Thanks for your descriptive and nice explanation...
Regards,
-- Raman
- Original Message -----
From: "Richard Huxton" &l
On Thursday 05 February 2004 08:28, Raman wrote:
> Hi Richard,
> Follwing are the Results that I get
> WHEN I run "between" query like
>
> ((CURRENT_TIME(0) AT TIME ZONE "interval" (time_difference)) BETWEEN
> (start_time::time - send_before_time::time)
> and start_time::time)
I think the issue i
an Garg
-- Raman
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Raman" <[EMAIL PROTECTED]>; "pgsql-sql"
<[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 1:33 AM
Subject: Re: [SQL] TIME ZONE SQL
> On Wed
On Wednesday 04 February 2004 17:57, Raman wrote:
>
> This query runs fine when i have
> time_difference value like +5:30 +5:00 i.e. works fine for positive values
> but failes for negative values i.e. -7:00, -6:00 etc
>
> I don't know WHY WHY... pls help
> I am helpless.
Can you give example outp
help me to solve the above problem . thanks in advance.
Tomasz Myrta <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/27/2004 10:56 AM CET
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject: Re: [SQL] time series data
Dnia 2004-01-2
Dnia 2004-01-27 02:42, Użytkownik [EMAIL PROTECTED] napisał:
Hi,
thanks for the info..btw can u pls explain a little bit detail since
i can't get thru yr solution.
thanks in advance
insert into time_table (time_key,year_id,month_id,month_desc,day_id)
select
newid,
extract('year' from you
Hi,
thanks for the info..btw can u pls explain a little bit detail since i can't get thru yr solution.
thanks in advance
Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał:
> Use this integer sequence and interval datatype to get date result:
> your_date='1994-01-01'::date+'1 day'::i
Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał:
Use this integer sequence and interval datatype to get date result:
your_date='1994-01-01'::date+'1 day'::integer * time_key
^^^
Sorry, use interval here.
Regards,
Tomasz Myrta
-
Dnia 2004-01-21 09:53, Użytkownik [EMAIL PROTECTED] napisał:
time_key integer not null default nextval('time_seq'::text)
> Example of data in time table:
> Time_keyyr_idmonth_idmonth_desc day_id
> 1999 1 Jan 1
> 1999 1 Jan 2
> 2000
On Wed, 30 Jul 2003, Anagha Joshi wrote:
> Hi All,
> I'm using PG-7.2.4 on Solaries.
> When I do:
>
> template1=# select time(6576);
> ERROR: TIME(6576) precision must be between 0 and 13
>
> Where am I wrong?
IIRC time(n) refers to the type time with a precision of n
and n is limited as stated
> I'm using PG-7.2.4 on Solaries.
> When I do:
>
> template1# select time(6576);
> ERROR: TIME(6576) precision must be between 0 and 13
>
> Where am I wrong?
What's the purpose of this function? And where did you find it in the
docs?
I didn't see it before.
Regards, Christoph
On Tue, 2003-07-22 at 04:22, Christoph Haller wrote:
> >
> > Pseudo code:
> >
> > begin trans
> > select * from table1
> > WAIT FOR 20 SECS
> > update table1 set blah = 'blah'
> > end transcation
> >
> > In pgplsql, Im looking for something like a function that I can use to
> make the process to wa
Girish Bajaj writes:
> In pgplsql, Im looking for something like a function that I can use to
> make the process to wait for 20 secs before continuing to execute the
> next sql statment?
There is no built-in support for that, but you could write your own
function in C that accomplishes that, for
>
> Pseudo code:
>
> begin trans
> select * from table1
> WAIT FOR 20 SECS
> update table1 set blah = 'blah'
> end transcation
>
> In pgplsql, Im looking for something like a function that I can use to
make the process to wait for 20 secs before con
tinuing to execute the next sql statment?
>
AFAIK
On Sat, Jul 12, 2003 at 09:00:19 +0200,
Erik Thiele <[EMAIL PROTECTED]> wrote:
> hi
>
> I am having problems with understanding of date/time/interval handling
> in postgresql and sql in general.
>
> a,b are TIMESTAMP WITHOUT TIME ZONE
> c is INTERVAL
>
> mathematics tell me:
>
> a-b = (a+c) -
On 6/2/03 11:04, "Ludwig Lim" <[EMAIL PROTECTED]> wrote:
> Are there cases when a TIME data type is a better
> choice over the TIMESTAMP data type?
Surely this depends on the nature of the data that you want to represent?
If you're researching into sleep patterns and want to represent the time
Hi Tomasz:
--- Tomasz Myrta <[EMAIL PROTECTED]> wrote:
>
> Probably you are right, but you can cast into
> timestamp before using these functions.
> Do you really need to care amount of storage?
I was just thinking if both TIMESTAMP and TIME have
use the same amount of space (I was think TIME
Ludwig Lim wrote:
Hi:
Are there cases when a TIME data type is a better
choice over the TIMESTAMP data type?
It seems that PostgreSQL (I'm using 7.2.3)
encourage its users to use TIMESTAMP over TIME data
type. I said this because of the following:
a) More functions for DATE and TIMES
Roberto Mello <[EMAIL PROTECTED]> writes:
> On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote:
>> I think your complaint is not that you get an interval, but that you
>> want it displayed differently. See to_char() ...
> It was not a complaint in any way. I apologize if I came across like
On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote:
> Roberto Mello <[EMAIL PROTECTED]> writes:
> > Is there any way to make a timestamp difference operation not return an
> > interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> > or whatnot.
>
> I think your complain
On Fri, Nov 08, 2002 at 16:11:05 -0500,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Roberto Mello <[EMAIL PROTECTED]> writes:
> > Is there any way to make a timestamp difference operation not return an
> > interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> > or whatnot.
>
> I
Roberto Mello <[EMAIL PROTECTED]> writes:
> Is there any way to make a timestamp difference operation not return an
> interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> or whatnot.
I think your complaint is not that you get an interval, but that you
want it displayed diff
On Fri, Nov 08, 2002 at 11:20:02 -0700,
Roberto Mello <[EMAIL PROTECTED]> wrote:
>
> Is there any way to make a timestamp difference operation not return an
> interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> or whatnot.
When you take a difference of two timestamps, y
In Conclusion:
7.0.2 by default outputs the time span as 00:00:00 no matter what format
you put in.
There is no need to convert it!
Thanks to Mark for all your help!!
At 11:03 AM 8/22/00 -0400, Mark Volpe wrote:
>SELECT '0:00:00'::time + '@ 2 hours 10 mins 6 secs'::timespan;
>
> ?column?
>---
SELECT '0:00:00'::time + '@ 2 hours 10 mins 6 secs'::timespan;
?column?
--
02:10:06
Mark
"Brian C. Doyle" wrote:
>
> Mark,
>
> On your 7.0 box would you do:
>
> SELECT '0:00:00'::time + '@ 2 hours 10 mins 6 secs':timespan;
>
> For me and see if it will convert it! Need to decide
I tried it on a box with postgres 6.5.3 and I got the result you did. On
postgres 7.0 I get 02:10:06 for both results. You should upgrade to 7.0 - it
is _much_ better.
Mark
"Brian C. Doyle" wrote:
>
> Mark,
>
> I tried that and had to change it to:
>
> SELECT '0:00:00'::timespan + '02:10:06':
I'm not sure at all what you are asking, but I'm thinking you're trying to
convert a "timespan" to a "time". Try adding it to a time like this:
SELECT '0:00:00'::time + '02:10:06'::timespan;
Mark
"Brian C. Doyle" wrote:
>
> Hello all,
>
> I have a query result of @ 2 hours 10 mins 6 secs and I
Mark,
I tried that and had to change it to:
SELECT '0:00:00'::timespan + '02:10:06'::timespan;
To get any response. the response i got was
@ 2 hours 10 mins 6 secs
Still in the wrong format
If is use :
SELECT '0:00:00'::time + '02:10:06'::timespan;
It get
No such function 'time_timespan'
"Thomas Lockhart" <[EMAIL PROTECTED]> replied to:
"Itai Zukerman" <[EMAIL PROTECTED]>
> > I'm currently doing this:
> > SELECT symbol, date_trunc('minute', posted),
> > min(price), max(price), avg(price)
> > FROM trade
> > GROUP BY symbol, date_trunc('minute', posted);
> > to get a
> > SELECT symbol, date_trunc('minute', posted),
> > min(price), max(price), avg(price)
> > FROM trade
> > GROUP BY symbol, date_trunc('minute', posted);
Hmmm... I'm not sure how to go about doing this for, say, 5 minute
intervals. Basically, I want a function:
date_round( time
> I'm currently doing this:
> SELECT symbol, date_trunc('minute', posted),
> min(price), max(price), avg(price)
> FROM trade
> GROUP BY symbol, date_trunc('minute', posted);
> to get a list of minute-averages of trade prices. I get the feeling
> that this is bad form, that I should
63 matches
Mail list logo
