var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trimming a DateTime
Probably easy but I'd like the best way to do it:
I have a datetime column with A LOT of rows. I'd like a select statement to return each date with everything after the hour part set to zero.
For example, if my column has the following values:
I know I can do this with a function and a couple of casts but there must be an easier (and faster) way!?!?
Convert(char(13), YourValue, 120)+':00:00.000'