??? ????????, ? MySQL ???? ??? ???????? ???? ?????? ??? ???????? ???: date ? datetime. ?????? ???????, ?? ????, ???????? ??????????? ????????? ??????? ? ????????? ?????? ???? ??????? ? ?????. ??? ?????????? ?? MySQL ?????? ?????? ???? ?? ???????? ?????? ?????????????? ????????? ????????:
2012-03-03 2012-03-03 12:00:00
?????? ? PHP ? ??????????? ???????? ?????? ? ?????? ???????????? ??? ?????????? ?????? ???? Unix timestamp, ?????????????? ?? ???? ????? ?????????? ?????? ????? "?????? ?????" (???????? ??????? ?????? 1970 ????) ? ??????? ????????.
????? ??? ?????? ???????? ???????? ?? ?????????????? ????? ???????? ????, ?????? ? ?.?. ? ???????? ?? ? PHP-??????? mktime, ?? ? ????????? ??????? ?????. ?????????? MySQL-??????? Unix_timestamp, ??????? ????????? ????????????? ???? ?? ??????? MySQL ? ?????? Unix timestamp ?? ????? ???????. ???????????? ????????? ???????:
SELECT created AS created_mysql, Unix_timestamp(created) AS created_unix FROM articles;