"Francisco Hernandez" <[EMAIL PROTECTED]>
> anyone know of a good book or books on database modeling?
> like for entity relationship diagrams and such..
To get a good life, go with Chris Date's rather difficult two volume set.
-dlj.
Got it: -U with date.
-dlj.
- Original Message -
From: "David Lloyd-Jones" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 9:27 PM
Subject: [SQL] Week of the Year?
> I'm probably staring right at it.
I'm probably staring right at it. (One of the difficulties with RTFMing, is
having too many docs!)
Is there anything in the API that produces the week of the year, from 1 to
52 or 53 depending on the week of the year, and the days that are in that
week?
Many thanks.
"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
