Equivalent TRUNC - 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 2000 Forums

SQL Server Development (2000)

Equivalent TRUNC

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-11-12 : 08:27:17

Rudolf writes "Hello.

Please, can you advise? I need know function for SQL server which is equivalent to function TRUNC for ORACLE.

Thanks a lot

Regards

Rudo"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-11-12 : 08:41:27

How about ROUND?


declare @d decimal(4,2)
select @d = 67.89
select @d, round(@d,1,1)

Jay White
{0}

X002548
Not Just a Number

15586 Posts

Posted - 2003-11-12 : 09:43:26

It would be nice if you told us what TRUNC does...

I think it's equivilant might be FLOOR

But I think it even includes dates....for example to get rid of Time data...

It's been awhile....

Brett

8-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources