The 7th tip of DB Query Analyzer
MA Gen feng
( Guangdong Unitoll Services incorporated, Guangzhou 510300)
Abstract Because in different RDBMS, filed value of date type has different precision, DB Query Analyzer will return the different date type value correspond to the RDBMS.
Key words DB Query Analyzer
‘Connect’ to ODBC Data Source ‘test_sqlserver’
4 Connect to MS SQL Server
After logged in MS SQL Server, input the SQL statement and execute it. Then you can get the date type field value in database.
This is shown in Figure 2.
Figure 2 Get the date type field value in MS SQL Server
5 Connect to Sybase
After logged in Sybase, input the SQL statement and execute it. Then you can get the date type field value in database.
This is shown in Figure 3.
Figure 3 Get the date type field value in Sybase
6 Connect to DB2
After logged in DB2, input the SQL statement and execute it. Then you can get the date type field value in database.
This is shown in Figure 4.
Figure 4 Get the date type field value in DB2
DB Query Analyzer 5.03 download URL:
http://xiazai.zol.com.cn/detail/43/420901.shtml
http://www.unitedpowersoft.com/UpFile/DBQueryAnalyzer_English_503.rar
DB Query Analyzer Simplified Chinese version 5.03 download URL:
http://xiazai.zol.com.cn/detail/27/264455.shtml
Remarks :
Please uninstall the former version first, then install the latest version.
马根峰本人的微信公众号：
万能数据库查询分析器
马根峰的博客：
CSDN博客：http://blog.csdn.net/magenfeng
新浪博客： http://blog.sina.com.cn/magenfeng
官方网址： http://www.unitedpowersoft.com/
更多精彩文章，技术分享，敬请期待