Hi, Could someone please give me an easy way to remember how to convert DATE_TIME into manipulative items? I've seen so many ways to convert to time and date - I'm confused about the math that is being used - or if someone knows of a good whitepaper? I have sql books and the TSM guides - and can't seem to find any references to this field.
Thanks in advance, Jane %%%%%%%%%%%%%%%%%%%%%%%%%%%% Jane Bamberger IS Department Bassett Healthcare 607-547-4784 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of John Monahan Sent: Monday, February 18, 2002 6:12 PM To: [EMAIL PROTECTED] Subject: Re: Select statement You can also: select cast(filespace_name as char(40)) as "Filespace Name".................. John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-484-5435 http://www.compures.com Andrew Raibeck <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/16/2002 07:11 AM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: Select statement Are you asking how to increase the width so that the file space name doesn't wrap to multiple lines? While this example doesn't wrap, it does illustrate a method you can use to adjust the output column widths. STANDARD WIDTH: select filespace_name, node_name, capacity from filespaces FILESPACE_NAME NODE_NAME CAPACITY ------------------ ------------------ -------------------- \\raibeck\c$ RAIBECK 44481.4 CUSTOM WIDTH (40 columns for FILESPACE_NAME): select filespace_name as "FILESPACE NAME ", node_name, capacity from filespaces FILESPACE NAME NODE_NAME CAPACITY ---------------------------------------- ------------------ -------------------- \\raibeck\c$ RAIBECK 44481.4 Note: The "as" specification for FILESPACE_NAME is padded with blanks to bring the entire column width to 40. When running in batch mode, if you want the display to appear in tabular format rather than list format, put the select command in a macro, say, "select.mac". Then invoke dsmadmc like this: dsmadmc -id=adminid -pa=xxxxx -displaymode=table macro select.mac or like this this to redirect output to a file: dsmadmc -id=adminid -pa=xxxxx -displaymode=table macro select.mac > select.out 2>&1 Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. From: Hunley, Ike [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 4:36 PM To: [EMAIL PROTECTED] Subject: Select statement Hi all, I hope someone out there has the answer for this. How do I increase the output field size for filespace_name so I can output the filespace_name along with quantity and node_name? Thanks
