Page 1 of 1

[SOLVED] convert a month into integer

Posted: Tue May 10, 2005 7:31 am
by gurjit
Hi all,

how do i convert lets say 'Jan', 'Dec', 'Sep' into a integer value '1','12','9'?

The month is in the database as a 3 letter character.

Posted: Tue May 10, 2005 7:35 am
by phpScott
simple swith statement

Code: Select all

switch($month)
{
  case "jan":
    $mon = 1;
    break;
  case "feb":
    $mon = 2;
    break;

// etc.....
}
echo $mon;

Posted: Tue May 10, 2005 7:38 am
by infolock

Code: Select all

SELECT DATE_FORMAT('Jan','%d');

Posted: Tue May 10, 2005 7:57 am
by gurjit
thanks worked great