From: Matthew Hagerty <matthew@venux.net>
To: pgsql-interfaces@postgreSQL.org
Subject: [off topic] Date and time fields
Date: Mon, 08 Mar 1999 17:39:50 -0500
Message-ID: <4.1.19990308173042.009df880@mail.venux.net> (raw)
Greetings,
Sorry for the off topic post, but the pgsql-sql list has almost no traffic
and I have never received an answer there :(
Could someone give me a basic run down on how to use/do date and time
checking and comparing. For example, I want to know how long someone is
logged into my site, so each time they request a page I update a "time"
field in my table. How can I check to see if more than, say 5 or 10
minutes has passed? I've come to learn that is *can't* be as simple as
something like this:
select * from temp where (logintime + '10 minutes') < time 'now'::datetime;
Also, what is the double colon? I only use it here because I saw it used
all over in the online docs. ;)
Thank,
Matthew
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-interfaces@postgresql.org
Cc: matthew@venux.net
Subject: Re: [off topic] Date and time fields
In-Reply-To: <4.1.19990308173042.009df880@mail.venux.net>
* 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