[dba-SQLServer] SQL Server - Make Date Field Display 2 Digit Year Only

To all,

I have a date field in a table in SQL Server 2000, which displays the date as DD/MM/YYYY.  Does anyone know how to make the date field just hold a 2 digit year DD/MM/YY ?

Thanks in advance for any help on this.


Paul Hartland
paul.hartland at fsmail.net
07730 523179