Under Tools / Options / Data Editor / Formatting there are a number of predefined format strings for 3 different data types: Date, DateTime, and Floating point numbers. It's good that we can change the format string if a custom format is wanted. Of which I have done for displaying microseconds for the DateTime type.
Unless I am doing something incorrect, when a format string in chosen, that format appears to apply to all like data types when being displayed in any Data Editor (example many results grids from different SQL statements). My question is why isn't the precision determined from the column data type?
According to BOL, the precision of SmallDateTime is 1 minute with typical rounding rules. DateTime the precision is microseconds with unique rounding rules. DateTime2 the default precision is 100 nanoseconds or 10 to the power of -7. In addition, the precision of fractional seconds for DateTime2 can be specified by the user. In addition, if the user does a CAST or CONVERT to a specific precision for a DateTime type in a SELECT, that one-format-fits-all for DateTime is applied when displayed.
Is this as designed? Am I doing something wrong? Or is this on the bug list to be fixed at a later date?
DateTime display formats
Re: DateTime display formats
Sorry for the delay on this.
We will fix this issue in the next product build and will notify you once it's available for downloading.
We will fix this issue in the next product build and will notify you once it's available for downloading.
-
- Posts: 33
- Joined: Tue 06 Dec 2016 19:49
Re: DateTime display formats
I've installed the upgraded version 5.5.196.
By default, the datetime display format follows the precision of the datatype now. Even when CAST or CONVERT is used. This is quite helpful. Thank you and thanks to the developer that spent the time to clean that up. Little things like this really do improve the utility of the program.
By default, the datetime display format follows the precision of the datatype now. Even when CAST or CONVERT is used. This is quite helpful. Thank you and thanks to the developer that spent the time to clean that up. Little things like this really do improve the utility of the program.
-
- Posts: 15
- Joined: Fri 09 Nov 2012 20:10
Re: DateTime display formats
Same thing here, thank you for changing this!MEngelbyDev wrote:I've installed the upgraded version 5.5.196.
By default, the datetime display format follows the precision of the datatype now. Even when CAST or CONVERT is used. This is quite helpful. Thank you and thanks to the developer that spent the time to clean that up. Little things like this really do improve the utility of the program.
Re: DateTime display formats
Thank you for the replies.
Please let us know if any questions arise.
Please let us know if any questions arise.
-
- Posts: 33
- Joined: Tue 06 Dec 2016 19:49
Re: DateTime display formats
The version 6.0.330 has lost this quality-of-life improvement. If you could in a future version, please restore the display of the datetime values to the precision of the datatype. Thank you.
Re: DateTime display formats
Could you please provide us the actual and expected results?
Screenshots would be also of help.
You can send the reply straight to our support system at supportATdevartDOTcom.
Screenshots would be also of help.
You can send the reply straight to our support system at supportATdevartDOTcom.