实在是找不到资料:::类型转化; ( 积分: 0 )

W

wutaoqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-26

• #1

请问:
SQL中,如何将datetime(2007-10-26 15:15:50)类型转换成Float类型???

 

D

dcx0026

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-26

• #2

ding

 

D

dcx0026

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-26

• #3

select cast(cast('2007-10-26 15:15:50' as datetime) as decimal(18,8)) as dtValue

 

U

unjiang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-26

• #4

用delphi的数据类型就可以，先放到一个时间变量，再换成float类型。具体要试试，我这没有ide。

 

W

wutaoqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-12-07

• #5

接受答案了.