NYCPHP Meetup

[nycphp-talk] Help converting MySQL datetime to month

Jon Baer jonbaer at jonbaer.com
Thu Oct 19 23:57:58 EDT 2006


You can also now do it directly in MySQL ... might be available as  
UDF on older versions.

mysql> select monthname('2006-10-19') as month;
+---------+
| month   |
+---------+
| October |
+---------+
1 row in set (0.00 sec)

- Jon

On Oct 19, 2006, at 9:28 PM, Randal Rust wrote:

> I have a function that does what I want, I just find it hard to
> believe that there isn't something better. So any pointers would be
> greatly appreciated.
>
> function convertDatetime($value){
> 	$value=explode(" ", $value);
> 	$value=explode("-", $value[0]);
> 	$y=$value[0];
> 	$m=$value[1];
> 	$d=$value[2];
> 	switch($m){
> 		case '01':
> 			$m='January';
> 			break;
> 		case '02':
> 			$m='February';
> 			break;
> 		case '03':
> 			$m='March';
> 			break;
> 		case '04':
> 			$m='April';
> 			break;
> 		case '05':
> 			$m='May';
> 			break;
> 		case '06':
> 			$m='June';
> 			break;
> 		case '07':
> 			$m='July';
> 			break;
> 		case '08':
> 			$m='August';
> 			break;
> 		case '09':
> 			$m='September';
> 			break;
> 		case '10':
> 			$m='October';
> 			break;
> 		case '11':
> 			$m='November';
> 			break;
> 		case '12':
> 			$m='December';
> 			break;
> 		}
> 	$dt=$m.' '.$d.', '.$y;
> 	$value=$dt;
> 	return $value;
> 	}
>
> -- 
> Randal Rust
> R.Squared Communications
> www.r2communications.com
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php




More information about the talk mailing list