Re: Select statements
2002-06-19 11:16:25
Yes, this is standard SQL. What you have to do is change the ORDER BY
clause to
ORDER BY 1
Date(backup_start) is a generated column result not the backup_start column
anymore. The way it works is you specify the relative column position in
the order by or group by when you do this.
tsm: TSMPRD00>select date(backup_start), node_name, filespace_name from
filespac
es where backup_start<=timestamp(current_date - 110 days ) order by 1
Unnamed[1] NODE_NAME FILESPACE_NAME
---------- ------------------ ------------------
2002-01-28 N10637 SYSTEM OBJECT
2002-01-28 N10637 SYSTEM OBJECT
2002-01-28 N10637 \\n10637\c$
Above is the sample result.
Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Select statements, Jolliff, Dale
- Re: Select statements, PINNI, BALANAND (SBCSI)
- Re: Select statements,
Seay, Paul <=
- Re: Select statements, Jolliff, Dale
- Re: Select statements, Prather, Wanda
- Re: Select statements, Jolliff, Dale
|
|
|