On 14/09/2016 9:23 PM, Clemens Ladisch wrote:
David Crayford wrote:
How do I do something similar to DB2 decimal() function which will add trailing
zeros to precision?
You could use the standard SQL CAST() to convert the value back into a number,
by why not simply sort by the original
Greetings,
I've just started using sqlite to (ironically) report on z/OS DB2 stats.
I've written a query where the results look a bit strange. I group by
the DB2 plan name and order by the maximum
CPU time. The sort order looks incorrect as you can see in the report
below. I'm certainly not
Of course. How do I do something similar to DB2 decimal() function which
will add trailing zeros to precision? I tried round(col,6) but it
knocked off the trailing zero like 12.12345.
On 14/09/2016 9:10 PM, Clemens Ladisch wrote:
David Crayford wrote:
9.733366
595.509361
29.117646
28.607606
typing aspect.
I've built it on a z/OS mainframe with very little changes and it works
great in the z/OS UNIX environment. I'm wondering what it will take to
get it to work
in the native file system.
On 2016/09/14 3:19 PM, David Crayford wrote:
Of course. How do I do something similar to DB2
4 matches
Mail list logo