best way to deal with time?

[teenlife_org_uk]

Hello, I have an article submission and view script (i wrote it). It is the first thing I have ever tried to program (php first language ive ever tried). I have the articles stored in a mysql database. At the minute I am just using the basic date function to hold a record of when the article was submittes but I am wondering if there is a better way to deal with it? I need to time to the second (for order by function) and just the date for display. I was currently doing this with two different entries. I am wondering if there is an easier way that will also mean I am able to manipulate the date and not be using yyyy-mm-dd and instead dd-mm-yyyy?

[AstroTeg]

You may want to use the field type DATETIME. Check out MySQL's site (http://www.mysql.com) because there's a lot of tricks you can do with these fields. One of them is DATE_FORMAT() which works similar to how PHP's date() function works. You can use DATE_FORMAT() to reformat the date into something you'd like to see.

But no, you can not directly change the way the date and datetime fields are displayed in the database itself. But DATE_FORMAT() should do it...

[teenlife_org_uk]

Thank you! That's exactly what I need! 😃