Here’s an easy way of extracting ISO dates from a datetime column:
select top 10 convert(varchar(10),starttid, 120) as datum -- style = 120 results in yyyy-mm-dd from pass
Result:
2005-08-02 2005-08-04
Technobabble from a .Net developer on the loose…
