On 08-May-01 Jack Sasportas wrote:
>
> The Goal is to have the Time stamp looking like 12:24 (military time OK)
>
> and the date 05-08-2001 or even 05-08-01.
>
> The MySQL db looks like so:
> date -00-00
> time 00:00:00
>
> I don't seem to really be able to vary the DB form
2001 17:46
To: php
Subject: Re: [PHP] Date & Time Formatting ??
Here is what I am trying to do, but I get the wrong date:
$t_data_array[1]=date("m/d/y",mysql_result($db_result,$db_record,'date'));
Then I simply print the value in the arraythis date instead of 05/08/0
e info (there are loads of examples in
> the user notes).
>
> HTH
> Jon
>
> -Original Message-
> From: Jack Sasportas [mailto:[EMAIL PROTECTED]]
> Sent: 08 May 2001 17:28
> To: php
> Subject: [PHP] Date & Time Formatting ??
>
> OK I have read many examp
are loads of examples in
the user notes).
HTH
Jon
-Original Message-
From: Jack Sasportas [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2001 17:28
To: php
Subject: [PHP] Date & Time Formatting ??
OK I have read many examples, old posts etc, but I am looking for a
detailed explanation as to
OK I have read many examples, old posts etc, but I am looking for a
detailed explanation as to how to do this.
First is when I write to a mysql database using the now() function, the
time stamp looks like so when I display the time back to the browser.
204:24:06 ( This should have been 12:24pm
When you are doing you select try something more along the lines of:
select date_format(date, '%e,%c,%Y') from tblmycoolstuff;
I got most of this stuff from
http://www.mysql.com/doc/D/a/Date_and_time_functions.html You need to look
at the table on that page to get the date to print out exactly a
> Also I'd like to if possible to be able to enter and display the date in
> Australian / European Time format (DD,MM,)
> I'm currently entering it on the form using three text fields and then
> rearanging them to the Format in mySQL and indserting it as a string, but
I
> don't know how to 'br
On Fri, 19 Jan 2001, Jamie wrote:
> I'm fairly new to SQL and PHP and I'm haveing trouble useing the Date
> functions of Both Systems, so I'd be greatfull if someone can help.
> What I'm trying to do is have an 'administrator' be able to enter info
> through a form to a mySQL database. Then on a
I'm fairly new to SQL and PHP and I'm haveing trouble useing the Date
functions of Both Systems, so I'd be greatfull if someone can help.
What I'm trying to do is have an 'administrator' be able to enter info
through a form to a mySQL database. Then on a seperate page have the info
reread and disp
9 matches
Mail list logo
