https://sqlines.com/ 2026-05-06T01:35:43+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2025-12-04T08:40:23+00:00 https://sqlines.com/sybase-to-oracle/char?rev=1764837623&do=diff In Sybase ASE, the CHAR(n) data type stores fixed-length, blank padded character strings with the maximum size of @@pagesize bytes. In Oracle, CHAR(n) can store up to 2,000 bytes. Sybase ASE: -- Review the pagesize SELECT @@pagesize /* 2,048 */ -- Sample table CREATE TABLE specs ( note CHAR(30), data CHAR -- CHAR(1) ); text/html 2022-12-28T10:56:50+00:00 https://sqlines.com/sybase-to-oracle/convert_datetime?rev=1672225010&do=diff In Sybase Adaptive Server Enterprise (ASE) you can use CONVERT function to convert a string expression in the specified format (style) to a datetime data type (DATE, DATETIME etc.). In Oracle you can to use TO_TIMESTAMP function. Note that Sybase ASE CONVERT and Oracle formats are different. text/html 2022-12-28T11:49:30+00:00 https://sqlines.com/sybase-to-oracle/convert_string_datetime?rev=1672228170&do=diff In Sybase Adaptive Server Enterprise (ASE) you can use CONVERT function to convert a DATETIME value to a string with the specified format. In Oracle you can use TO_CHAR function. Note that Sybase ASE CONVERT and Oracle formats are different. Sybase ASE: text/html 2022-12-29T15:38:31+00:00 https://sqlines.com/sybase-to-oracle/datename?rev=1672328311&do=diff In SAP Sybase Adaptive Server Enterprise (ASE) you can use DATENAME function to extract the specified unit (a date part such as year, month, day etc.) from a datetime value. In Oracle you can use TO_CHAR function with the specific format type. Sybase ASE: text/html 2022-12-27T23:17:19+00:00 https://sqlines.com/sybase-to-oracle/day?rev=1672183039&do=diff In Sybase Adaptive Server Enterprise (ASE) you can use DAY function to get the day (an integer number) of the specified datetime. In Oracle you have to use EXTRACT(DAY FROM datetime) function. Sybase ASE: -- Get the day SELECT DAY('2022-12-28'); # 28