ADSM-L

Learning SQL-queries

2003-07-21 07:58:17
Subject: Learning SQL-queries
From: brian welsh <brianwelsh3 AT HOTMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 21 Jul 2003 13:57:56 +0200
Hello,

On the list I see on a regular base sql-queries with something like this:
- CAST(SUM(BYTES/1024/1024)
or
- substr(cast(min(start_time) as char(26)),1,19) as "DATETIME
or
- cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as
char(8)) as "Length

The basic sql I understand now, but I want to know more about 'substr' and
'cast' and so on. Is there some-one who can give me the title of a book
where this is explained or maybe an url or something?

Thanks in advance,

Brian.

_________________________________________________________________
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/

<Prev in Thread] Current Thread [Next in Thread>