Thanks a bunch.
I knew there must be an elegant and simple solution.
I bet I could apply this to a few nasty recursive relationships too.
AJ ONeal
On Mon, Sep 22, 2008 at 10:11 AM, Alberto Treviño <[EMAIL PROTECTED]> wrote:
> On Monday 22 September 2008 09:43:12 am Alvin ONeal wrote:
> > Let's
Hey everyone,
I got a couple of PVR devices. A couple of these
http://www.aminocom.com/products/ipstb/aminet125.html and a couple of these
http://www.aminocom.com/products/ipstb/aminet500.html.
The 500 has an 80GB hard disk, composite/component/s-video output,
stereo/sp-dif output, mpeg2 decorder
On Monday 22 September 2008 09:43:12 am Alvin ONeal wrote:
> Let's say I have a table in a database that stores the exact time and
> each time that I do a query on that table I want it to retrieve that time
> in three distinct formats - one as unix time, one as mm/dd/ and one
> as hh:mi:ss am.
Alvin ONeal wrote:
> Let's say I have a table in a database that stores the exact time and each
> time that I do a query on that table I want it to retrieve that time in
> three distinct formats - one as unix time, one as mm/dd/ and one as
> hh:mi:ss am.
>
> How can I create a view of the table
Let's say I have a table in a database that stores the exact time and each
time that I do a query on that table I want it to retrieve that time in
three distinct formats - one as unix time, one as mm/dd/ and one as
hh:mi:ss am.
How can I create a view of the table so that SELECT * FROM PunchCa