Hi all

I had a search of the php forum and I found a couple of things but I'm not quite sure how to implement what I found so....

I have a form in an admin section of a website that I submit to a table. It submits the current days date into a date field.

When the page with the info pulled from the table is displayed, it displays the data thus: YYYY-MM-DD

I would prefer it to be DD-MM-YYYY

Now my query is, at what point do I ask the date to be in the desired format?

On submission?
When I SELECT from the database?
When I echo the results?

Thanks for any tips!

On select, it depend of your database. Check the manual for that.
For mysql, go there:
http://dev.mysql.com/doc/refman/4.1/...on_date-format

For doing it in php, use the date() function.
the date function requires an unix timestamp. So either return an unix timestamp from your db (see first point) or use php mktime() function.
http://www.php.net/manual/en/function.date.php
http://www.php.net/manual/en/function.mktime.php

The best way is to place the data in the database the way you want it displayed. To do this, you would use the following function:

date('d-m-Y')

This should give you the result you desire.

I have some ideas on how to change the date format on current and old posts. Let me know if you need them.

I strongly disagree with neoRunner.

If you do that, it means that you store the date on a text format.
It means too that you won't be able to use the database time and date functions when it come to sort or discard some records based on the dates.

Let the db store dates as dates, and learn to use the db function that will allow you to change the way it's displayed.
In the long run, it'll make your life easier.

I didn't know of such a function. Can you elaborate?

Read your dbms manual, and for mysql, read my second post.
There are a full range of date manipulation functions built right into every dbms engines.
Use them !
http://dev.mysql.com/doc/refman/4.1/...on_date-format