Previous Topic

Next Topic

Book Contents

Book Index

Scripting - ColFormat

This statement is used to specify the display format of a column in the subsequent query.

Specify the following:


--aqt colformat,colname=salary,format=currency

Select * from test.employee

If you wish to format more than one column, you can do this either on separate format lines, or on the same line:

--aqt format,colno=5,format=$###,##0.00,colno=6,format=yyyy-MM-dd

Select * from test.employee

Advanced Query Tool
© 2023 Cardett Associates Ltd. All rights reserved.