> 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
Is the timestamp in UNIX format?
if yes, try date() http://www.php.net/manual/en/function.date.php
if no, try substr()
hope that helps :)
- Jeremy
- Original Message -
From: "Ragnar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 7:42 AM
Subject: [PHP] Formating
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...
I have a col
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 datevariables...
6 matches
Mail list logo
