php mysql日期转换小数

Question

I have a date. The format is:

1298588277.0

Note the decimal. This is from an xml feed so I cannot directly change the format. I am led to believe the decimal will be used later once "time runs out" as we all know.

What is the best way to store this as a single column value in a mysql database? What should I set the column as?

Answer 1

Any reason why you cannot use the DECIMAL column type?

ALTER TABLE `tablename` ADD `fieldname` DECIMAL( 15, 2 ) NOT NULL DEFAULT '0'

EDIT Ahh... read the comments before answering, eh? :embarrassed: