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

convert(YourDate,varchar(15),1)


At 12:00 PM 1/18/2007, you wrote:
>Date: Thu, 18 Jan 2007 12:01:54 +0100 (CET)
>From: paul.hartland at fsmail.net
>Subject: [dba-SQLServer] SQL Server - Make Date Field Display 2 Digit
>         Year    Only
>To: accessd <accessd at databaseadvisors.com>,     dba-sqlserver
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID:
>         <20389518.198761169118114607.JavaMail.www at wwinf3004.me-wanadoo.net>
>Content-Type: text/plain; charset=UTF-8
>
>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