Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Tuesday, February 25, 2014 2:44 PM
Points: 148, Visits: 112
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