> I have a column in a mysql table with a timestamp. The value of this
> column
> is for instance:
>
> 20020722185242
>
> How do i change the format on this to "DDMM" (22072002) in php?
SELECT DATE_FORMAT(date_column,'%d%m%Y') AS Formatted_Date FROM
your_table
There's no need to involve PH
s S. Kelly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 9:51 AM
To: 'Ragnar'; [EMAIL PROTECTED]
Subject: RE: [PHP] Formating datevariables...
Why not let mysql do it? It has a function do to exactly that, I
think...
But php's date() is the function you're looking
7:42 AM
Subject: [PHP] Formating datevariables...
> I have a column in a mysql table with a timestamp. The value of this
column
> is for instance:
>
> 20020722185242
>
> How do i change the format on this to "DDMM" (22072002) in php?
>
> Thanx
>
> -R
&g
lto:[EMAIL PROTECTED]]
Verzonden: dinsdag 23 juli 2002 01:51
Aan: 'Ragnar'; [EMAIL PROTECTED]
Onderwerp: RE: [PHP] Formating datevariables...
Why not let mysql do it? It has a function do to exactly that, I
think...
But php's date() is the function you're looking for...
-Orig
Select TIMESTAMP(date_column) AS mydate
Then when you display it use the date function
DATE('mdY',mydate)
-Original Message-
From: Ragnar [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 4:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Formating datevariables...
Why not let mysql do it? It has a function do to exactly that, I
think...
But php's date() is the function you're looking for...
-Original Message-
From: Ragnar [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 4:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Formating dat
I have a column in a mysql table with a timestamp. The value of this column
is for instance:
20020722185242
How do i change the format on this to "DDMM" (22072002) in php?
Thanx
-R
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
7 matches
Mail list logo
