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.