No, there is no provision for special formatting of numbers. You would
need some other program to format the numbers as you like. For example, if
you use Microsoft Excel to query the TSM server via the TSM ODBC driver,
you can format the columns in Excel to display numeric values with the
desired separators.
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] (change eye to i to reply)
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"Rupp Thomas (Illwerke)" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/01/2003 09:22
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Format numbers
Hi *SM-ers,
I would like to format the numbers I get from a SQL Select.
1558195645 should look like 1.558,195.645
Can this be done with SQL?
Kind regards
Thomas Rupp
Vorarlberger Illwerke AG
