|
|
|
| <?php
function long_date($a_date) {
//echos "Month day, year" ie.. December 21, 2002 from MySql date field 2002-12-21
$months = array("1" => "January",
"2" => "February",
"3" => "March",
"4" => "April",
"5" => "May",
"6" => "June",
"7" => "July",
"8" => "August",
"9" => "September",
"10" => "October",
"11" => "November",
"12" => "December");
$the_month = $months[substr($a_date,5,2)];
$the_day=substr($a_date,8,2);
$the_year=substr($a_date,0,4);
echo "$the_month $the_day, $the_year";
}
?> | |
|
|
| Finding the day of the week for a specific date.
Categories : PHP, Databases, MySQL, Date Time | | | mysql date/time converters
Categories : PHP, MySQL, Databases, Date Time | | | Data Retrieve from Mysql using AJAX with PHP
Categories : PHP, AJAX, Date Time, Databases, MySQL | | | Phorum, MySQL, Language, UK date format, MySQL UK Date format
Categories : PHP, Date Time, Strings, MySQL, Databases | | | List people whose birthdays fall on the current Day and Month
Categories : Databases, Date Time, MySQL, PHP | | | In Mysql, the 'datetime' data type is used to store date that looks like '2007-10-16 16:26:30'. we are going to design a function called mysqldate() that takes a mysql date and output format as input and outputs a well formated date.
Categories : PHP, Date Time, Databases, MySQL | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | Simple function to return the number of days in a time span between 2 given dates.
Categories : PHP, Date Time, MySQL, Databases | | | Checks Date-Input from HTML-Forms and converts to YYYY-MM-DD Format for MySQL Date-Fields
Categories : MySQL, Date Time, PHP, Databases | | | Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates.
Categories : PHP, Arrays, Date Time, Databases, MySQL | | | Count how many weeks in the month have a specified day, such as Mon, Tue, etc. Var avail - number of days - first day name of the month, occurrences of Sun, occurrences of Mon, etc. Allows you to calculate number of working hours exclude Holidays.
Categories : Calendar, Date Time, PHP, Databases, MySQL | | | How to Insert a Date Format Into MySQL from PHP
Categories : PHP, Databases, MySQL, Date Time, Beginner Guides | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | PHP Calendar Web App
Categories : PHP, Databases, MySQL, Date Time, Calendar | | | formating MySQL Timestamp to get a propper Output.
related : Timestamp, ereg_replace, mysql, substr
Categories : MySQL, PHP, Date Time, Databases | |
| | | | salem65 salem65 wrote : 891
<?
echo "Today`s Date:";
echo date("H:i, jS F Y");
?>
| | | | Alex Alexander wrote :893
...or use mysql DATE_FORMAT() function, e.g.
select d1, DATE_FORMAT(d1,`%M %d %Y`) AS d2 from sometable;
| |
|
|
|
