https://www.sqlines.com/ 2026-04-17T01:10:32+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2022-12-28T10:57:29+00:00 https://www.sqlines.com/sybase-to-postgresql/convert_datetime?rev=1672225049&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 PostgreSQL you can to use TO_TIMESTAMP function. Note that Sybase ASE CONVERT and PostgreSQL formats are different. text/html 2022-12-28T11:49:57+00:00 https://www.sqlines.com/sybase-to-postgresql/convert_string_datetime?rev=1672228197&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 PostgreSQL, you can use TO_CHAR function. Note that Sybase ASE CONVERT and PostgreSQL formats are different. text/html 2022-12-27T22:55:03+00:00 https://www.sqlines.com/sybase-to-postgresql/convert_time?rev=1672181703&do=diff In Sybase Adaptive Server Enterprise (ASE) you can use CONVERT function to convert an expression (a string i.e.) to TIME data type. In PostgreSQL you can to use CAST or various type conversion functions. Sybase ASE: -- Convert string to TIME SELECT CONVERT(TIME, '11:11'); # 11:11:00 AM text/html 2022-12-29T15:43:58+00:00 https://www.sqlines.com/sybase-to-postgresql/datename?rev=1672328638&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 PostgreSQL you can use TO_CHAR function with the specific format type. text/html 2022-12-27T23:15:03+00:00 https://www.sqlines.com/sybase-to-postgresql/day?rev=1672182903&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 PostgreSQL you have to use EXTRACT(DAY FROM datetime) function. Sybase ASE: -- Get the day SELECT DAY('2022-12-28'); # 28 text/html 2024-10-16T15:28:32+00:00 https://www.sqlines.com/sybase-to-postgresql/str_replace?rev=1729092512&do=diff In Sybase Adaptive Server Enterprise (Sybase ASE) you can use STR_REPLACE function to replace all occurrences of a substring in string. In PostgreSQL you can use REPLACE function. Sybase ASE: -- Replace 'bc' with '12' SELECT STR_REPLACE('abcd', 'bc', '12'); # a12d text/html 2024-10-16T17:28:40+00:00 https://www.sqlines.com/sybase-to-postgresql/tsql_outer_join?rev=1729099720&do=diff Sybase Adaptive Server Enterprise (ASE) supports legacy Transact-SQL syntax *= and =* for outer joins. In PostgreSQL you have to use ANSI SQL standard LEFT OUTER and RIGHT OUTER join syntax. Consider the following sample table: CREATE TABLE colors (name VARCHAR(30), category CHAR(1)); INSERT INTO colors VALUES ('Green', 'G'); INSERT INTO colors VALUES ('Red', 'R'); INSERT INTO colors VALUES ('Blue', 'B'); CREATE TABLE categories (name CHAR(1), note VARCHAR(30)); INSERT INTO…