Re: MySQL datetime extraction

Hello, This is a reply to an e-mail that you wrote on Sat, 19 Jul 2003 at 19:16, lines prefixed by '>' were originally written by you. > Given a date in MySQL datetime format, how do I extract the elements? > That is get the month, day, year, hour, ... > Thanks, > Yasir Bit off topic for this list, but see the DATE_FORMAT() function at http://www.mysql.com/doc/en/Date_and_time_functions.html David. -- phpmachine :: The quick and easy to use service providing you with professionally developed PHP scripts :: http://www.phpmachine.com/ Professional Web Development by David Nicholson http://www.djnicholson.com/ QuizSender.com - How well do your friends actually know you? http://www.quizsender.com/ (developed entirely in PHP)