Formatting of SELECT Query Output
- From: gadgetfan.john@xxxxxxxxxxxxxx
- Date: Tue, 16 Oct 2007 06:34:38 -0700
I'm using Adaptive Server 12.5 and have a couple of problems with
formatting the output of SQL SELECT queries for use in further
analysis. The general issue is that it's so inflexible in its output
formatting - there seems to be no format that doesn't include lots of
useless spaces, or will show a date AND time in a concise, all-numeric
form (ideally dd/mm/yy hh:mm:ss). I suppose I have to live with that
one.
However, there is another problem that is driving me insane, and I'm
wondering if it's just me. Every time I use CONVERT on a datetime
field (e.g. with display format 3, dd/mm/yy), every line of the output
includes both a line feed/return and a tab character, immediately
after the date. This means that each row becomes two rows, playing
havoc with the input to another program. I can't see any logical
reason for this aspect of the formatting. Is there something I can add
to the CONVERT function to prevent it? When I have over 100,000 rows
in my results, this issue isn't trivial.
--
John H, UK
.
- Follow-Ups:
- Re: Formatting of SELECT Query Output
- From: SybaseNeal
- Re: Formatting of SELECT Query Output
- From: Luc Van der Veurst
- Re: Formatting of SELECT Query Output
- Prev by Date: Re: Example of how to call a stored procedure from C using dblib - needed desperately
- Next by Date: Re: Example of how to call a stored procedure from C using dblib - needed desperately
- Previous by thread: RepServer - Exception when creating subscription: "RepDefinition doesn't exist"
- Next by thread: Re: Formatting of SELECT Query Output
- Index(es):
Relevant Pages
|
|
