SAP Knowledge Base Article - Preview

2850302 - Is there a server level parameter for timestamp_format - SAP ASE

Symptom

  • Is there a global setting for changing the datetime format without having to use convert?
  • For example:

select getdate()
go
--------------------------
May 20 20XX 1:32PM

  • Would like it to change  a different format, at the global level to a different view for example:

select convert(char(20), getdate(), 116)
go
----------------------------------------
May 20 20XX 21:24:29


Read more...

Environment

SAP Adaptive Server Enterprise

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

datetime_format timestamp_format date_format set option date format time_format time , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.