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 or time 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 timestamp_format, date_format, or time_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