On, Off

Off

Can only be set as a temporary option, for the duration of the current connection. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role.

This option indicates whether DATE, TIME, and TIMESTAMP values are returned to applications as a DATE, TIME, or TIMESTAMP data type or as a string.

When this option is set to On, the database server converts the DATE, TIME, or TIMESTAMP value to a string before it is sent to the client to preserve the date_format, time_format, or timestamp_format option setting.

Sybase Central and Interactive SQL automatically turn the return_date_time_as_string option On.

• date_format option
• time_format option
• timestamp_format option
• timestamp_with_time_zone_format option
• return_date_time_as_string connection property