On, Off

Off

Can be set as a temporary option only, for the duration of the current connection.

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