DATETIME field format ???

habbardone

I have aproblem formating for the mysql DATETIME field.

I have tried this but it didn't work:

$timestp = time("Y-m-d hh:mm:ss");

When I just wanted the date in a mysql DATE field this worked:
$today = date("Y-m-d");

Does antone know how I format the field so I can store both
time and date ?

Thanks

Shrike

The date function you use for YYYY MM DD can do the full date/time structure too.

habbardone

So do you mean that if I sort by the date field - the ones with the same date are ordered by time ?

And if so is the ordering in the same direction ?

Thanks

habbardone

ALSO

in my mysql database - do I need to use the DATETIME field type or just the DATE type to hold the information ?

mrhappiness

DATE holds: 2005-04-08
TIME holds: 10:12:55

DATETIME holds: 2005-04-08 10:12:55

the sort direction can be specified by using ASC (default) or DESC

habbardone

Thanks mr happiness,

It would be nice to store my time stamp in my
mysql db as the YYYY-MM-DD hh:mm:ss format that
the msql DATETIME uses because it is easily readable.

BUT is there a function that converts this into the timestamp format
so that I can use php to change the date with my script at another time ?

thanks if you know of one . 🙂

Weedpacket

[man]strtotime[/man] in PHP; there is another one in MySQL that I'm sure someone more familiar with MySQL will be able to point you to.

mrhappiness

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html lists all of the date and time functions of mysql.

there is one function to create a unix timestamp and there are many other functions as well. maybe you don't need to calculate anything in php at all

habbardone

Mr Happiness posted

the sort direction can be specified by using ASC (default) or DESC

Do you mean like this ?

...ORDER $sorter, create_date DESC";

Thanks

mrhappiness

maybe, i don't know 😉

why don't you just try?

btw:
your ORDER BY will sort by $sorter in ascending order and if more than one entries exist with the same $sorter they will be sorted by create_date in descending order