Oracle table names, field names are case-insensitive, Sybase is strictly differentiated
2.Oracle To_char ()/to_date ()---sybase convert ()
--oracle:to_char (sysdate, ' dd-mm-yyyy Day '), To_date (String,format)
--sybase:convert (char (15), date, 108), CONVERT (datetime,string,108)
--with Sybase convert at the end of the third parameter introduction
3.Oracle substr ()--Sybase's substring ()
4.Oracle NVL ()--Sybase's IsNull ()
5.Oracle Fetch system Time sysdate--Sybase's GETDATE ()
6.Oracle Decode--Sybase's case and then
--oracle:select Decode (PARAM,NULL,RESULTA,RESULTB) from Res;
--sybase:select case where param is null and resulta else RESULTB end from Res;
7. External connection
--oracle:select * from TableA A, TableB b where a.id=b.id (+);
--sybase:select * from TableA A,tableb b where a.id*=b.id;
8.insert method
--oracle:insert into TableA (SELECT * from TableB where tableb.id= "");
--sybase:insert into TableA (id,name,age) (SELECT * from TableB where tableb.id= ""); Insert table must clear column name
Attached: Sybase convert the third parameter describes
That's the format you want to save when you convert your time into string lines.
101 USA Mm/dd/yy
102 ANSI YY.MM.DD
103 British/french Dd/mm/yy
104 German Dd.mm.yy
Italian Dd-mm-yy
106-dd Mon yy
107-mon DD, yy
108-hh:mm:ss
109 (*) Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM)
Mm-dd-yy USA
111 JAPAN YY/MM/DD
ISO YYMMDD
113 (*) Europe default + milliseconds dd Mon yyyy hh:mm:ss:mmm (24h)
114-hh:mi:ss:mmm (24h)
(*) ODBC canonical yyyy-mm-dd Hh:mi:ss (24h)
121 (*) ODBC canonical (with milliseconds) Yyyy-mm-dd hh:mi:ss.mmm (24h)
126 (* *) ISO8601 yyyy-mm-dd Thh:mm:ss:mmm (no spaces)
130* Kuwaiti dd Mon yyyy hh:mi:ss:mmmAM
131* Kuwaiti Dd/mm/yy Hh:mi:ss:mmmAM
This article is from the "unrestrained" blog, please be sure to keep this source http://shaotao.blog.51cto.com/7606729/1617496
Some of the differences between Oracle and Sybase