Date format error

dcjones

Hi all.

I have a form with a feild that when clicked on pops up a calendar which I can select a date I wnat to insert into the field.

The date inserted displays "03 Apr, 2007". I want to store that date in a date field in my MYSQL data table, a field named "f_date" set to date type.

When I save the record the data field "f_date" displays "0000-00-00" which I take it the date input is not getting inserted to the table.

My insert field code is

<input name="f_date"  type="text" class="bodytext" id="f_date" onclick='scwShow(this,this);' value="" size="15" />

Is there a way I can format the date input into the correct format.

many thanks

sid

you could try [man]strtotime/man, which would give you the date as unix timestamp, from where you can put it into whatever format you want (see [man]date/man f.ex.).

however "never trust user-supplied input"!

dcjones

Hi and many thanks for your reply.

I was thinking and I have changed the MYSQL data field to a TIMESTAMP type.

I am trying to format the output so it is readable. This is what I have

<?php echo  $row_agent_report['f_date'],date("d-m-Y",$timestamp) ; ?>

If I enter a date as "14-04-2007" the output is "20140420070000"

How can I display as the input was i.e "14-04-2007"

Any ideas

bradgrafelman

With MySQL's DATE_FORMAT() function.