Web Global Net Web Application & Web Development Project Center

Current Month Name = <?php echo date('F') ?>
Current Year = <?php echo date('Y') ?>

used mainly in hidden fields on a form or display purposes

The date() function formats a local time/date.

This coding will display like this :
<?php echo date('F') ?> <?php echo date('d') ?> <?php echo date('Y') ?>  - <?php echo date('g') ?>:<?php echo date('i') ?> <?php echo date('a') ?>

February 18 2011 - 2:42 pm

<?php echo date('l') ?>, <?php echo date('F') ?> <?php echo date('d') ?> <?php echo date('Y') ?>  - <?php echo date('g') ?>:<?php echo date('i') ?> <?php echo date('a') ?>

Saturday, February 18 2011 - 2:42 pm

This code will insert this format

<?php echo date('Y') ?><?php echo date('m') ?><?php echo date('d') ?>

2011-05-31

<?php echo date('n') ?>/<?php echo date('j') ?>/<?php echo date('Y') ?>

6/25/2019

You can also use this to format a record set date value like this:

<?php echo date(" l F d, Y", strtotime($row_rsview_invoice['stop']));?>

Will show in this format - Saturday June 04, 2011

Another way to do this :

<?php
  // make date normal month/dd/yyyy
  $mysqldate = $row_rscurrentreunionevents['reunion_date'];
  $mydate = date("l F j, Y",strtotime($mysqldate));
  echo $mydate;
?>

Will show in this format - Saturday June 4, 2011

which is the correct mysql way to insert into a date filed

Syntax

Description

Specifies how to return the result:
d - The day of the month (from 01 to 31)
D - A textual representation of a day (three letters)
j - The day of the month without leading zeros (1 to 31)
l (lowercase 'L') - A full textual representation of a day
N - The ISO-8601 numeric representation of a day (1 for Monday through 7 for Sunday)
S - The English ordinal suffix for the day of the month (2 characters st, nd, rd or th. Works well with j)
w - A numeric representation of the day (0 for Sunday through 6 for Saturday)
z - The day of the year (from 0 through 365)
W - The ISO-8601 week number of year (weeks starting on Monday)
F - A full textual representation of a month (January through December)
m - A numeric representation of a month (from 01 to 12)
M - A short textual representation of a month (three letters)
n - A numeric representation of a month, without leading zeros (1 to 12)
t - The number of days in the given month
L - Whether it's a leap year (1 if it is a leap year, 0 otherwise)
o - The ISO-8601 year number
Y - A four digit representation of a year
y - A two digit representation of a year
a - Lowercase am or pm
A - Uppercase AM or PM
B - Swatch Internet time (000 to 999)
g - 12-hour format of an hour (1 to 12)
G - 24-hour format of an hour (0 to 23)
h - 12-hour format of an hour (01 to 12)
H - 24-hour format of an hour (00 to 23)
i - Minutes with leading zeros (00 to 59)
s - Seconds, with leading zeros (00 to 59)
e - The timezone identifier (Examples: UTC, Atlantic/Azores)
I (capital i) - Whether the date is in daylights savings time (1 if Daylight Savings Time, 0 otherwise)
O - Difference to Greenwich time (GMT) in hours (Example: +0100)
T - Timezone setting of the PHP machine (Examples: EST, MDT)
Z - Timezone offset in seconds. The offset west of UTC is negative, and the offset east of UTC is positive (-43200 to 43200)
c - The ISO-8601 date (e.g. 2004-02-12T15:19:21+00:00)
r - The RFC 2822 formatted date (e.g. Thu, 21 Dec 2000 16:01:07 +0200)
U - The seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)