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
Posted Wednesday, October 14, 2009 8:51 AM


Group: General Forum Members
Last Login: Wednesday, February 18, 2015 11:57 AM
Points: 148, Visits: 115
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