On Fri, Apr 23, 2004 at 11:46:52AM +0300, Alexei Chetroi wrote:
> Date: Fri, 23 Apr 2004 11:46:52 +0300
> From: Alexei Chetroi <[EMAIL PROTECTED]>
> User-Agent: Mutt/1.5.5.1+cvs20040105i
> To: [EMAIL PROTECTED]
> Subject: [SQL] converting unix seconds to timestamp
>
&
Hi,
I wish to convert unix seconds which are from 1970 to timestamp and connot
find appropriate function for it. I know how to convert timestamp to unix
second with extract(epoch FROM ...) but not reverse.
Please Help.
Regards
--
Alexei Chetroi
---(end of
On Sun, Sep 07, 2003 at 09:09:35AM -0400, Rod Taylor wrote:
> [skip]
> >
> > Thanks everybody for responses. I'm trying this one, but psql complains
> > on queries like "SELECT min(date), event FROM events GROUP BY item" that
> > events must be GROUPed or used in an aggregate function. Why thi
On Sat, Sep 06, 2003 at 01:21:36PM -0400, Rod Taylor wrote:
> > I'd like to write a query which returns following information regarding
> > each item: item, date of very first event, very last event.
> > Is this possible? I think I can write several SELECT queries and
> > procces them by an appli
Hi All,
I need a little help regarding writing some subqueries. For example I
have a table "items" which contains columns: itemid, description; and
another table "events" with columns: itemid, date, event. events.itemid
references items.itemid. Table events contains events regarding some
itemid'
