Formatting data in the results table in the database console

Hi,

Is there a way to specify how the results of a query should be formatted in the database console?
For example, numbers get displayed in the comma separated form (like 10,014,949) but there are times when you would not want this. I looked around but I could not find an option for this anywhere. I am using 10.5 RC.

Thanks

3 comments
Comment actions Permalink

Hi,

I'm not sure that there is a setting somewhere. Depending on what you're doing, you could change the select to something:

SELECT CAST(NumericID As VARCHAR(20)) AS ID FROM W2

Hope that helps,
Dirk

0
Comment actions Permalink

Thanks. I was hoping there would a better solution than me trying to convert every numeric column everytime.

0
Comment actions Permalink

I think this deserves a feature request.
http://youtrack.jetbrains.net/issues/IDEA#newissue=yes

If you create one, post the link here so that other can vote/comment on it.

-tt

0

Please sign in to leave a comment.