Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Formating DateTime Expand / Collapse
Author
Message
Posted Wednesday, October 14, 2009 8:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 26, 2016 1:02 PM
Points: 148, Visits: 121
I have a DateTime column in my cube. This actually just contains DATE - the time component is always 00:00:00

How do I set formatting on this column so it shows up only as MM/DD/YYYY and ignores the HH:NN:SS portion of the column? I want to set this in the cube so that any client that connects to the cube get the same format and I do not have to go around formatting the column for each client.
Post #802813
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse