Re: as in SQL

From: Chris Eastwood <c.undieseastwood_at_gu.edu.au>
Date: Mon, 21 Dec 1998 01:17:56 GMT
Message-ID: <75k43i$6fe$1@kraken.itc.gu.edu.au>

HiYa

In article <75dmfh$rqq$1_at_nnrp1.dejanews.com>, alt_at_interchange.co.uk wrote:
>The 'as' is used to stipulate what follows is a column alias (but the as is
>optional).
>
>eg select to_char(datefield,'dd-mon-yy hh24') as TIME
>or
>select to_char(datefield,'dd-mon-yy hh24')TIME

Ahhh ... thanks ... I have used the aliasing "optioning out" the as for so long that I didn't know that the "option" existed.

I learn something new every day ... well most days, not like yesterday, which brings the average down a little, but I should think that its a good 5 out of 7 days.......

;-)

See Ya
(when bandwidth gets better ;-)

Chris Eastwood

Photographer, Programmer               email    ua.ude.ug.cti_at_doowtsae.c
Motorcyclist and dingbat               WWW   http://chrise.itc.gu.edu.au

please remove undies for reply

---

Ohhh ... you work all day, slave over a hot stove all night  yet you *still* have time for sadomasochism ... how do you do it?

A little man hurts me.

<ding>

    Oh Mister Mean ... Oh Mister Mean
    15 Minutes with him and you'll be blue and green     Studded belts and leather whips
    Bondage trousers on his hips
    Wack and punish as you dust with Mister Mean   Ohhhh he whips me around the house in minutes ... lets get cracking ... Received on Sun Dec 20 1998 - 19:17:56 CST