how to get day of month from a date stored variable

Posted on 2003-03-25
Medium Priority
Last Modified: 2012-05-04
Hi friends

i have the date in one variabe

$date = "2002/05/30";

how to get day of month from $date variable

I used as echo date("j",$date) but 1 is printed .
I dont know why
pls correct it.

Question by:kulapjohn
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 8201431
you can with this command
list($year,$month,$day) = explode("/",$date);

$date = "2002/05/30";

list($year,$month,$day) = explode("/",$date);

echo "year:".$year."<br>";
echo "month:".$month."<br>";
echo "day:".$day."<br>";

Accepted Solution

vulpine earned 150 total points
ID: 8201443
You need to convert the date to a format php will interpret. So we use the strtotime() function.
This is what i have come up with:

$date = "2003-07-26";
$date = strtotime($date);
$aday = date("l",$date);
print ($aday);
LVL 12

Expert Comment

ID: 8201457
from the php documentation
(PHP 3, PHP 4 )

date -- Format a local time/date
string date ( string format [, int timestamp])

Returns a string formatted according to the given format string using the given integer timestamp or the current local time if no timestamp is given.

Note: The valid range of a timestamp is typically from Fri, 13 Dec 1901 20:45:54 GMT to Tue, 19 Jan 2038 03:14:07 GMT. (These are the dates that correspond to the minimum and maximum values for a 32-bit signed integer). On windows this range is limited from 01-01-1970 to 19-01-2038.

To generate a timestamp from a string representation of the date, you may be able to use strtotime(). Additionally, some databases have functions to convert their date formats into timestamps (such as MySQL's UNIX_TIMESTAMP function).

The following characters are recognized in the format string:

a - "am" or "pm"

A - "AM" or "PM"

B - Swatch Internet time

d - day of the month, 2 digits with leading zeros; i.e. "01" to "31"

D - day of the week, textual, 3 letters; e.g. "Fri"

F - month, textual, long; e.g. "January"

g - hour, 12-hour format without leading zeros; i.e. "1" to "12"

G - hour, 24-hour format without leading zeros; i.e. "0" to "23"

h - hour, 12-hour format; i.e. "01" to "12"

H - hour, 24-hour format; i.e. "00" to "23"

i - minutes; i.e. "00" to "59"

I (capital i) - "1" if Daylight Savings Time, "0" otherwise.

j - day of the month without leading zeros; i.e. "1" to "31"

l (lowercase 'L') - day of the week, textual, long; e.g. "Friday"

L - boolean for whether it is a leap year; i.e. "0" or "1"

m - month; i.e. "01" to "12"

M - month, textual, 3 letters; e.g. "Jan"

n - month without leading zeros; i.e. "1" to "12"

O - Difference to Greenwich time in hours; e.g. "+0200"

r - RFC 822 formatted date; e.g. "Thu, 21 Dec 2000 16:01:07 +0200" (added in PHP 4.0.4)

s - seconds; i.e. "00" to "59"

S - English ordinal suffix for the day of the month, 2 characters; i.e. "st", "nd", "rd" or "th"

t - number of days in the given month; i.e. "28" to "31"

T - Timezone setting of this machine; e.g. "EST" or "MDT"

U - seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)

w - day of the week, numeric, i.e. "0" (Sunday) to "6" (Saturday)

W - ISO-8601 week number of year, weeks starting on Monday (added in PHP 4.1.0)

Y - year, 4 digits; e.g. "1999"

y - year, 2 digits; e.g. "99"

z - day of the year; i.e. "0" to "365"

Z - timezone offset in seconds (i.e. "-43200" to "43200"). The offset for timezones west of UTC is always negative, and for those east of UTC is always positive.

Unrecognized characters in the format string will be printed as-is. The "Z" format will always return "0" when using gmdate().

Example 1. date() example

echo date ("l dS of F Y h:i:s A");
echo "July 1, 2000 is on a " . date ("l", mktime(0,0,0,7,1,2000));

You can prevent a recognized character in the format string from being expanded by escaping it with a preceding backslash. If the character with a backslash is already a special sequence, you may need to also escape the backslash. Example 2. Escaping characters in date()

echo date("l \\t\h\e jS"); // prints something like 'Saturday the 8th'

It is possible to use date() and mktime() together to find dates in the future or the past. Example 3. date() and mktime() example

$tomorrow  = mktime (0,0,0,date("m")  ,date("d")+1,date("Y"));
$lastmonth = mktime (0,0,0,date("m")-1,date("d"),  date("Y"));
$nextyear  = mktime (0,0,0,date("m"),  date("d"),  date("Y")+1);

Note: This can be more reliable than simply adding or subtracting the number of seconds in a day or month to a timestamp because of daylight savings time.

Some examples of date() formatting. Note that you should escape any other characters, as any which currently have a special meaning will produce undesirable results, and other characters may be assigned meaning in future PHP versions. When escaping, be sure to use single quotes to prevent characters like \n from becoming newlines. Example 4. date() Formatting

/* Today is March 10th, 2001, 5:16:18 pm */
$today = date("F j, Y, g:i a");                 // March 10, 2001, 5:16 pm
$today = date("m.d.y");                         // 03.10.01
$today = date("j, n, Y");                       // 10, 3, 2001
$today = date("Ymd");                           // 20010310
$today = date('h-i-s, j-m-y, it is w Day z ');  // 05-16-17, 10-03-01, 1631 1618 6 Fripm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.');   // It is the 10th day.
$today = date("D M j G:i:s T Y");               // Sat Mar 10 15:16:08 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h');     // 17:03:17 m is month
$today = date("H:i:s");                         // 17:16:17

To format dates in other languages, you should use the setlocale() and strftime() functions.

WordPress Tutorial 1: Installation & Setup

WordPress is a very popular option for running your web site and can be used to get your content online quickly for the world to see. This guide will walk you through installing the WordPress server software and the initial setup process.

LVL 15

Expert Comment

ID: 8201671
yes, true, but à part from this, you may as well use this simple thing to get the month of the day :
-either the "$exploded=explode('/',$date)" thing and then take "$day=$exploded[2];"
-either (if your date is alsways complete, ie 10 characters) "$day=substr($date,8,2);"

Expert Comment

ID: 8201950
listen to VGR, excellent answers 100% of the time


if(ereg ("([0-9]{2,4})[^0-9]([0-9]{1,2})[^0-9]([0-9]{1,2})", $yourdate, $values))
     // invalid format

this will allow for :-
2 to 4 digits for year
1 to 2 digits for month
1 to 2 digits for day
AND allow any non-numeric character as a seperator

LVL 15

Expert Comment

ID: 8202512
very good. That's the first time I have to accept to recognize that a regexp solution is better than a "normal programming" one ;-)

I may even use it :D

"c'est dire si je l'aime" ;-)

Author Comment

ID: 8202881
yes, it is ok now,Thanks

LVL 15

Expert Comment

ID: 8203668
a bit over-complicated, but if you like it ;-) :/

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question