[PHP] Date Time Formatting ??

2001-05-08 Thread Jack Sasportas
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

RE: [PHP] Date Time Formatting ??

2001-05-08 Thread Jon Haworth
(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 examples, old posts etc, but I am looking for a detailed explanation as to how

Re: [PHP] Date Time Formatting ??

2001-05-08 Thread Jack Sasportas
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 how to do this. First

RE: [PHP] Date Time Formatting ??

2001-05-08 Thread Jon Haworth
] 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/01 comes out 12/31/69 Thanks! Jon Haworth wrote: I think

RE: [PHP] Date Time Formatting ??

2001-05-08 Thread Don Read
On 08-May-01 Jack Sasportas wrote: snip 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 format.

Re: [PHP] Date/Time Formatting

2001-01-19 Thread Ignacio Vazquez-Abrams
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

Re: [PHP] Date/Time Formatting

2001-01-19 Thread Richard Lynch
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 'break'