List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:February 19 2007 11:09pm
Subject:Re: Year - Field type
View as plain text  
have you try using the datatype YEAR for you table field/column ?

Mickalo
----- Original Message ----- 
From: "John Berman" <John_Berman@stripped>
To: <mysql@stripped>
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/mysql?unsub=1
>
Thread
Year - Field typeJohn Berman19 Feb
  • Re: Year - Field typeMike Blezien20 Feb
    • RE: Year - Field typeJohn Berman20 Feb
      • RE: Year - Field typeSST - Adelaide)20 Feb
        • RE: Year - Field typeJohn Berman21 Feb