DBMS Function Differences

最新推荐文章于 2024-07-12 10:47:52 发布

zhengziwei

最新推荐文章于 2024-07-12 10:47:52 发布

阅读量261

点赞数

分类专栏： SQL 文章标签： function postgresql sql server sybase oracle mysql

本文链接：https://blog.csdn.net/zhengziwei/article/details/4806162

版权

11 篇文章 0 订阅

订阅专栏

DBMS Function Differences
Function	Syntax
Extract part of a string	Access uses `MID()`. DB2, Oracle, and PostgreSQL use `SUBSTR()`. MySQL, SQL Server, and Sybase use `SUBSTRING()`.
Datatype conversion	Access and Oracle use multiple functions, one for each conversion type. DB2 and PostgreSQL use `CAST()`. MySQL, SQL Server, and Sybase use `CONVERT()`.
Get current date	Access uses `NOW()`. DB2 and PostgreSQL use `CURRENT_DATE`. MySQL uses `CURDATE()`. Oracle uses `SYSDATE`. SQL Server and Sybase use `GETDATE()`.

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

关注关注