Viewing 3 posts - 16 through 19 (of 19 total)
Well in the case of my database, I understand why they separated it the way they do. It may have not been the best way, I think it was the...
September 23, 2009 at 7:47 am
#1057511
Never Mind I was foolish. varchar(20) is the answer.
September 22, 2009 at 2:41 pm
#1057138
Where did I go wrong, it is adding to the year, yet in your code it does not.
SELECT DateOn, TimeOn, TimeOff, DateOff,
CONVERT(SMALLDATETIME,(CONVERT(VARCHAR(8), DateOn, 101) + ' ' + TimeOn)) DateTimeOn,
CONVERT(SMALLDATETIME,(CONVERT(VARCHAR(8),...
September 22, 2009 at 2:39 pm
#1057137