var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
At the design level of Table fields in MS SQL where the Data Type is Date or DateTime, is there any way I can change the Column Properties to set the output format to DD/MMM/YYYY?
Formatting is done in your presentation layer (e.g. webpage, report, application, etc).
Data types do not have formatting options.
Home | Blog
Thanks, I thought that was probably the case.
The only display format in ANSI/ISO Standard SQL is ISO-8601 (yyyy-mm-dd HH:MMS) This what you get from the DATE, TIME and DATETIME2(n) data types. I assume you have stopped using the old Sybase proprietary DATETIME and SMALLDATETIME types by now.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors