https://sqlines.com/ 2026-04-22T16:23:49+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2012-03-29T15:37:44+00:00 https://sqlines.com/sybase-asa/functions/dateformat?rev=1333035464&do=diff DATEFORMAT function converts a datetime expression to string using the specified format. Quick Example: SELECT DATEFORMAT('2010-09-17', 'Mmm DD, YYYY'); -- Result: Sep 17, 2010 Overview Sybase SQL Anywhere DATEFORMAT function: Syntax DATEFORMAT(datetime_expression, format_string) Return Value VARCHAR Last Update: Sybase SQL Anywhere 12 text/html 2023-04-01T09:13:17+00:00 https://sqlines.com/sybase-asa/functions/string?rev=1680340397&do=diff STRING function concatenates one or more strings into a single string. Quick Example: -- Concatenate strings AB and CD SELECT STRING('AB', 'CD'); -- Result: ABCD STRING Function Overview Summary information: Syntax STRING(string_expression, ...) Return Type LONG VARCHAR NULL Values NULL value in a parameter is treated as '' (empty string) But STRING returns NULL if all parameters are NULL Parameter Conversion Number and datetime parameters are implicitly converted to s…