Formatting data in the results table in the database console Follow

Created May 11, 2011 21:55

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

Dirk Dittert

Created May 13, 2011 05:43

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

Gesly

Created May 13, 2011 21:25

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

Taras Tielkes

Created May 24, 2011 07:23

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

Please sign in to leave a comment.