开发者

substraction field type time

I'm a beginner php-mysql programmer,, and i have some problem,, 1 of them is ....

i have a table "gangguan83" with field

urut_gangguan int(15) -> primary key.
lv int(10),
trip datetime,
masuk datetime,
current int(10),
ens int(10),
....

how can i query if m开发者_Go百科y statement like this :

ens = (lv * 1,73 * 0,9 * current * (masuk-trip))

please help me. Thanks very much before.


SELECT lv * 1.73 * 0.9 * current * (masuk - trip) AS ens
...
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜