From: David Loh <david@bizsurf.com>
To: pgsql-sql@postgresql.org
Subject: A minute in timestamp
Date: Thu, 8 May 2003 14:40:22 +0800
Message-ID: <003501c3152c$b3872a30$f92c2c0a@david> (raw)
Hi all.
After some read of postgres' documentations, I can't found any command perform similar task like timediff() in other SQL server, the only thing I got is date_part().
For my case, what I actually need is to create a trigger (before insert) that check previous record (1 mins), grab the previous value and deduct new value (NEW.myValue := Previous.myValue - NEW.myOtherValue), and since the records are insert every minutes,the function should trace back to the record entered a minute ago (for e.g, 12:38 will check for record of 12:37 and grab the value), hence timestamp even include the milli-second, is there any command/trick to check if the record are entered approximately 55-65 secs (1 minutes +/- 5 secs) ?
So far, I'd tried 'select * from myTable where date_part('minute',Update_Time - now()) = 1;', but this SQL statement will only return result if the hour:minute:milli-seconds MATCH EXACTLY !! (12:38.51451->12:39.51451 = match, the rest aren't). Then I switch to 'select * from myTable where Update_Time = now()-interval '1 minute'', but it still the same :(
If any of you guys have a solution to solve my problems, please kindly let me know, your help is greatly apprepriate.
Thanks in advance.
Regards,
David Loh
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david@bizsurf.com
Subject: Re: A minute in timestamp
In-Reply-To: <003501c3152c$b3872a30$f92c2c0a@david>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox