date()

General discussions related to php

Moderators: macek, egami, gesf

JakeWilliams
New php-forum User
New php-forum User
Posts: 4
Joined: Mon Nov 18, 2002 4:21 pm

date()

Postby JakeWilliams » Fri Dec 27, 2002 5:05 pm

8O

I need assistance getting date() to work.
I have a date field on a mySQL table.
The field, of course, is shown as yyyy-mm-dd.
I need it to show as mm-dd-yyyy.

I tried:
echo date("m d y", $databaseField);
...and that doesn't work. The date displayed isn't even close to the real date.

I changed my database field to a timestamp. It still doesn't show the correct date.

A little help is appreciated.

Thanks,
Jake

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

Postby Joan Garnet » 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
;)

JakeWilliams
New php-forum User
New php-forum User
Posts: 4
Joined: Mon Nov 18, 2002 4:21 pm

using explode

Postby JakeWilliams » Tue Dec 31, 2002 6:18 am

Explode does work, however, I lose the long month description.
In order to get the description that date() should give me I use the functions explode and jdmonthname:

Code: Select all

function displayDate($date) {
  $dateArray = explode("-", $date);
  $dateMonth = jdmonthname(juliantojd($dateArray[1],$dateArray[2],$dateArray[0]),0);
  $returnDate = $dateMonth." ".$dateArray[2].", ".$dateArray[0];
  return($returnDate);
}


Is this the normal approach to converting a date? I was hoping to pass my date into date() and be done with it.

jake

User avatar
Oleg Butuzov
Last Samuray
Last Samuray
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby Oleg Butuzov » 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:

Postby Joan Garnet » 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!


Return to “PHP General”

Who is online

Users browsing this forum: No registered users and 3 guests