大家帮忙看看出了什么问题

[tidus]

echo date("Y-M-d, H:i a","20030108202144");

得出的结果是：2038-Jan-19, 11:14 am 。

20030108202144是从Mysql里取出的Timestamp。

[uGain]

要把20030108202144写成mktime()形式的timestamp

[telescope]

这不是什么问题呀,我认为正常啊

[wuxyun]

echo date("Y-M-d, H:i a",mktime(20,21,44,01,08,2003));

[tidus]

echo date("Y-M-d, H:i a",mktime(20,21,44,01,08,2003));

出来的结果是:

2002-Dec-31, 20:21 pm

[hhzh426]

Column type Display format
TIMESTAMP(14) YYYYMMDDHHMMSS
TIMESTAMP(12) YYMMDDHHMMSS
TIMESTAMP(10) YYMMDDHHMM
TIMESTAMP(8) YYYYMMDD
TIMESTAMP(6) YYMMDD
TIMESTAMP(4) YYMM
TIMESTAMP(2) YY
这种格式是mysql自己设置的时间格式，不能用标准的转换函数来转换。
Although TIMESTAMP values are stored to full precision, the only function that operates
directly on the underlying stored value is UNIX_TIMESTAMP(). Other functions operate
on the formatted retrieved value. This means you cannot use functions such as HOUR()
or SECOND() unless the relevant part of the TIMESTAMP value is included in the formatted
value. For example, the HH part of a TIMESTAMP column is not displayed unless the
display size is at least 10, so trying to use HOUR() on shorter TIMESTAMP values produces
a meaningless result.
也就是说只能用select UNIX_TIMESTAMP(字段)这种方法来获取确切的时间值。或者你自己写解析函数。

[hhzh426]

你这个取出的timestamp是自定义的吧。
好象是2003-01-08 20:21:44的一种特殊表示形式。
我这儿有两种标准的时间表示形式
1040355114(精确到秒)
1041901270.058(精确到毫秒)

[tidus]

timestamp是mysql里面自动设置的。