$timestamp_for_my_birthday = mktime(0,0,0,10,16,1984);
$timestamp_for_the_next_day = mktime(0,0,0,10,17,1984);
if($time > $timestamp_for_my_birthday && $time < $timestamp_for_the_next_day){
// Time is on my birthday
}
要将其转换为MySQL查询:
$SQL = "SELECT * FROM dates WHERE date > $timestamp_for_my_birthday AND date < $timestamp_for_the_next_day;";
要按日期订购,我认为它会像:
SELECT * FROM dates ORDER BY FROM_UNIXTIME(时间,'%M%d%Y');
1
你能做一个吗?
SELECT DATE(FROM_UNIXTIME(my_field_name)) FROM table_x ORDER BY my_field_name
3 回答
您可以使用mktime()来获取要用于存储条目的时间戳:
http://us.php.net/manual/en/function.mktime.php
要将其转换为MySQL查询:
要按日期订购,我认为它会像:
SELECT * FROM dates ORDER BY FROM_UNIXTIME(时间,'%M%d%Y');
你能做一个吗?
您可以按时间戳列进行排序,但如果您想要记录属于哪一天的字符串表示,则可以使用
FROM_UNIXTIME(timestamp, 'format')
函数获取日期的任何部分 .可以根据此处的表格调整第二个参数中的格式值:http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format