在interbase的SQL中如何实现本地SQL的extract(month from ddd)

msb 2000-09-04 05:49:00

paradox用SQL在日期字段(ddd)中取月，在本地SQL可用extract(month from ddd)
interbase中如何实现？

...全文

46 回复打赏收藏转发到动态举报

写回复

回复

切换为时间正序

请发表友善的回复…

发表回复

InterBase中SQL语句执行分析工具(InterBase PLANalyzer)在Borland网站上下载的一个SQL分析工具，希望使用InterBase数据库并对自己的程序性能优化的朋友有些用处!

sql2000与InterBase,gdb文件打开,ODBC数据源,dts

EMS SQL Manager for InterBase/Firebird is a powerful tool for InterBase and Firebird administration and development. SQL Manager 2005 is compatible with any Firebird version up to 2.0 and InterBase version up to 7.5 and supports all of the latest features including trigger messages, BLOB filters, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder and Stored Procedure Debugger to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it. Key Features * Compatible with any Firebird server version up to 2.1 * Compatible with any InterBase server version up to 2007 * Rapid database management and navigation * Easy management of all InterBase and Firebird objects with Unicode support editors * Effective security management * Excellent visual and text tools for query building * Report designer with clear in use report construction wizard * Impressive Unicode compatible data export and import wizards working in background mode * Powerful visual database designer * Easy-to-use wizards performing InterBase and Firebird services in background mode * Powerful and easy-to-use graphical user interface * And other useful features

EMS SQL Manager for InterBase/Firebird is a powerful tool for InterBase and Firebird administration and development. SQL Manager 2005 is compatible with any Firebird version up to 2.0 and InterBase version up to 7.5 and supports all of the latest features including trigger messages, BLOB filters, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder and Stored Procedure Debugger to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it. Key Features * Compatible with any Firebird server version up to 2.1 * Compatible with any InterBase server version up to 2007 * Rapid database management and navigation * Easy management of all InterBase and Firebird objects with Unicode support editors * Effective security management * Excellent visual and text tools for query building * Report designer with clear in use report construction wizard * Impressive Unicode compatible data export and import wizards working in background mode * Powerful visual database designer * Easy-to-use wizards performing InterBase and Firebird services in background mode * Powerful and easy-to-use graphical user interface * And other useful features

SQLAPI++ is a C++ library for accessing multiple SQL databases Oracle SQL Server DB2 Sybase Informix InterBase SQLBase MySQL PostgreSQL SQLite SQL Anywhere and ODBC It uses native APIs of target DBMS so applications developed with SQLAPI++ library run swiftly and efficiently The product also provides a low level interface that allows developers to access database specific features By encapsulating a vendor"s API SQLAPI++ library acts as middleware and delivers database portability 适用于gcc 4 4 linux操作系统：RHEL CentOS 6 X">SQLAPI++ is a C++ library for accessing multiple SQL databases Oracle SQL Server DB2 Sybase Informix InterBase SQLBase MySQL PostgreSQL SQLite SQL Anywhere and ODBC It uses native APIs of target DBMS so applications developed with SQLAPI++ library run swiftly and efficiently The produc [更多]

5,386

社区成员

262,729

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章