James A. Lawrence (2/5/2008)
or...Select convert(char(10),getdate(),101)
Of course I'd use convert(char(10),getdate(),103)...
Which raises a question I haven't found an answer to:
Why does America (and nowhere else) write dates in their traditional order, i.e. month/day/year?
Everywhere else has a date order which either goes from specific to general (day-month-year) or the reverse (y-m-d). Why does America use a medium-small-large (m-d-y) ordering such that a mechanical 'odometer' would have to update the middle section first, then the left end, then the right end rather than the more logical left-to-right or right-to-left?
Derek