date()

General discussions related to php

Moderators: egami, macek, gesf

Post Reply
User avatar
Joan Garnet
Moderator
Moderator
Posts: 387
Joined: Sat Aug 03, 2002 2:56 am
Location: Mars
Contact:

Fri Dec 27, 2002 9:16 pm

Code: Select all

$my_date = explode("-", $date);
$final_date = $my_date[1]."-".$my_date[2]."-".$my_date[0];


That's it
;)

Oleg Butuzov
Last Samuray
Last Samuray
Posts: 824
Joined: Sun Jun 02, 2002 3:09 am

Tue Dec 31, 2002 7:11 am

Are you lazy cat ?

http://www.php.net/manual/en/function.date.php
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.

User avatar
Joan Garnet
Moderator
Moderator
Posts: 387
Joined: Sat Aug 03, 2002 2:56 am
Location: Mars
Contact:

Tue Dec 31, 2002 7:22 am

You can do it from your mysql query as well -->

Code: Select all

$sql = mysql_query(" SELECT date_format( date_column_name, '%M %D, %Y') as date FROM my_table ");


bye!

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 0 guests