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

Gustav Brock Gustav at cactus.dk
Thu Jan 18 05:44:43 CST 2007


Hi Paul

The datefield will always "hold" a 4-digit year, but you can format it as a string:

  SELECT CONVERT(varchar, datefield, 103) ...

/gustav

>>> paul.hartland at fsmail.net 18-01-2007 12:01 >>>
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





More information about the AccessD mailing list