paul.hartland at fsmail.net
paul.hartland at fsmail.net
Thu Jan 18 06:03:06 CST 2007
Thanks Gustav..... Message Received: Jan 18 2007, 11:46 AM From: "Gustav Brock" To: accessd at databaseadvisors.com Cc: Subject: Re: [AccessD] SQL Server - Make Date Field Display 2 Digit Year Only 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Paul Hartland paul.hartland at fsmail.net 07730 523179