Viewing 4 posts - 1 through 4 (of 4 total)
Someone, somewhere along this lie-laced diatribe mentioned theory versus real-world application. While Cimode appears to feel there is no real-world need to deviate from theoretical principles, one of his mentors,...
February 26, 2007 at 12:11 pm
You were correct - it did sort incorrectly. I made my dates YYYYMMDD using this code:
WHEN 'due_date' THEN LTRIM(STR(DATEPART(yyyy,a.due_date))) +
RIGHT('00'+LTRIM(STR(DATEPART(mm,a.due_date))),2) +
RIGHT('00'+LTRIM(STR(DATEPART(dd,a.due_date))),2)
Everything...
March 12, 2002 at 4:54 pm
Sorry - I missed the part in sample 2 on CASTing dates. I changed my code to convert my dates and then found that I needed to convert...
March 12, 2002 at 4:32 pm
I am trying to use this article's advice, but am getting wierd results. When I sort by any field which is date or numeric (proj_id or request_received) it...
March 12, 2002 at 3:59 pm
Viewing 4 posts - 1 through 4 (of 4 total)