Convert Number To Time - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Convert Number To Time

Author

Topic

mahsa_mr
Starting Member

22 Posts

Posted - 2008-10-21 : 08:29:49

Hi,
i want to convert data in char :

13.05
18.42,
19.08

to time and the find diff between time:
for example: diff between 19.08 and 5.58 should become 13.10.

plaese help.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-21 : 08:46:34

Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112967

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources