Mickalo I gave that a go now I have another issue
I can only enter years 1900 onwards so when I enter 1887 it changes the value to 0 John B -----Original Message----- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: 19 February 2007 23:10 To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Year - Field type have you try using the datatype YEAR for you table field/column ? Mickalo ----- Original Message ----- From: "John Berman" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Monday, February 19, 2007 11:45 AM Subject: Year - Field type > Hi > > Using mysql4 > > > Sure this is an easy one a field in my dbase is year of birth, its always a > 4 digit number, for some reason Im failing to sort by the field in my > results, it was originally a varchar field so I updated it to int but still > no luck. Pointers appreciated. > > Regards > > John Berman > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.412 / Virus Database: 268.18.2/692 - Release Date: 18/02/2007 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]