TSM.
Zlatko Krastev
IT Consultant
brian welsh <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
21.07.2003 14:57
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:Learn
d.com/sql/calc.html
Alex Paschal
Freightliner, LLC
(503) 745-6850 phone/vmail
-Original Message-
From: brian welsh [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 4:58 AM
To: [EMAIL PROTECTED]
Subject: Learning SQL-queries
Hello,
On the list I see on a regular base sql-queries
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,
