my problem is with date format
mysql support -mm-dd
but my client not use to enter date in -mm-dd format
he use to in dd-mm-yyy format
how can it possible to input date in
dd-mm- format
www.php.net/date will show you all the possibilities of formatting the date
bastien
Date: Sat, 22 Dec 2007 17:54:07 +0600
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] date format problem
my problem is with date format
Hello,
I have a field in my mysql db wich is a timestamp with the format
mmddhhmmss
and I would like to display it like:
dd/mm/
how do I do that?
Thank you in advance,
Dani
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
I have a field in my mysql db wich is a timestamp with the format
mmddhhmmss
and I would like to display it like:
dd/mm/
http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333
SELECT DATE_FORMAT(timestamp_col_name, '%d/%m/%Y') FROM table_name
--
PHP Database
Hi All, I have a date format of -MM-DD in MySQL and am showing it on a PHP page.
However I want to show it as
2 February, 2003
or 2 February
Can someone please help me. The date will not necessarily be todays date (I looked at
the datetime() function and the getdate() function but
strftime()
offers a lot of formatting options for dates.
Hope it helps.
RUBANOWICZ Lisa wrote:
Hi All, I have a date format of -MM-DD in MySQL and am showing it on a PHP page. However I want to show it as
2 February, 2003
or 2 February
Can someone please help me. The date will not
]
Subject: Re: [PHP-DB] Date format in
MySQL
02/03/2003
09:32 AM
$query = mysql_query(SELECT UNIX_TIMESTAMP(fieldname) AS date WHERE id = '1';);
$array = mysql_fetch_array($query);
$mydate = date(j F, Y,$array[date]);
Change fieldname and the where clause, and that should work.
If you want to further munipulate how it looks, just look at the
date
What if
$date=10-02-2002;
I tried it this way and the explode causes problems with the - in it
What would be the best way to deal with this should i just parse out the -?
Andrey Sosnitsky [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello CrossWalkCentral,
Hello, CrossWalkCentral.
You wrote 23 ñåíòÿáðÿ 2002 ã., 2:05:38:
So, explode() requires a seperator as a first argument.
You code is
$date= 10-01-2002;
list ($day, $month, $year) = explode(-, $date);
echo $year-$month-$day;
See PHP manual at http://www.php.net/manual/en/function.explode.php
That did it thanks
Andrey Sosnitsky [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello, CrossWalkCentral.
You wrote 23 ñåíòÿáðÿ 2002 ã., 2:05:38:
So, explode() requires a seperator as a first argument.
You code is
$date= 10-01-2002;
list ($day,
I am having problems coverting the followign date format. Does any one have
any insight on this.
$date= 10 01 2002
I need to conver this to Y-m-d
any help would be great
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello dear all,
in my mysql-db I have a date_tbl with this format: (20020531).
how is possible in PHP do display date_tbl's values in a more human-readable
format like 05-31-2002 or 31/05/2002 ?
thaks in advance,
regards
fabrizio
--
PHP Database Mailing List (http://www.php.net/)
Monday, June 10, 2002, 2:00:59 PM, you wrote:
in my mysql-db I have a date_tbl with this format: (20020531).
how is possible in PHP do display date_tbl's values in a more human-readable
format like 05-31-2002 or 31/05/2002 ?
Look at date and strtotime...
http://www.php.net/date
This function will fix your date display.
$sqldate=20020531;
$sqldate= fixdate($sqldate);
function fixdate($data){
$aux=;
$z=0;
for($i=0; $istrlen($data); $i++) {
if($i=3) {
$aux[0].=$data[$i];
}
if($i==4 or $i==5) {
$aux[1].=$data[$i];
}
if($i==6 or $i==7) {
: Monday, June 10, 2002 9:01 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] date format display
Hello dear all,
in my mysql-db I have a date_tbl with this format: (20020531).
how is possible in PHP do display date_tbl's values in a more
human-readable
format like 05-31-2002 or 31/05/2002
of seconds between
the Unix Epoch (January 1 1970) and the currend time and adds 5 hours (18000
seconds)
Hope this helps
Dobromir Velev
-Original Message-
From: Matt Nigh [EMAIL PROTECTED]
To: php-db [EMAIL PROTECTED]
Date: Wednesday, November 28, 2001 03:49
Subject: [PHP-DB] date format
hi,
i'm wondering if anyone could help me in formatting a date so it is 5 hours ahead of
the server time.
here's the code i'm using but it doesn't seem to work:
$date = date(F dS, Y g:i:s A,
mktime(date(g)+5,date(i),date(s),date(m),date(d),date(Y)) );
i've already looked in the manual and
try H as your hour format (date(H)+5)
although out of interest, at 9:51am, using either g or H gives me 2:51
pm
HTH
/beau
// -Original Message-
// From: Matt Nigh [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 28 November 2001 9:48 AM
// To: php-db
// Subject: [PHP-DB] date format
PROTECTED]]On
Behalf Of system
Sent: Saturday, July 14, 2001 5:17 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date Format
Friends,
I have a design, up and running scripts connected to MySQL.
How do I retrieve date formats and have it displayed as dd-mm- ?
I store them as DATE.
CK Raju
How I can format date in php query from MSSQL?
Jack
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Hi
Have a look in Books Online - the e-docs for MSSQL - search for the convert
function and all will be revealed.
Peter
- Original Message -
From: Jack [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 5:49 PM
Subject: [PHP-DB] Date format in MSSQL
How I can
Friends,
I have a design, up and running scripts connected to MySQL.
How do I retrieve date formats and have it displayed as dd-mm- ?
I store them as DATE.
CK Raju
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
PROTECTED]] On Behalf
Of system
Sent: Friday, July 13, 2001 8:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date Format
Friends,
I have a design, up and running scripts connected to MySQL.
How do I retrieve date formats and have it displayed as dd-mm- ?
I store them as DATE.
CK Raju
--
PHP
Hello all,
I'm on the last leg of a project I'm doing, and maybe I'm just too fried
but I've tried several things. Can anyone help:
I've created an Event Listing form. The script pulls the table names from
the DB and preg's them to create the field names for the form. Any field
name that
25 matches
Mail list logo