View previous topic :: View next topic |
Author |
Message |
psridhar Beginner
Joined: 16 May 2004 Posts: 68 Topics: 26
|
Posted: Wed Jan 12, 2005 4:10 am Post subject: Round off |
|
|
Hi
I have a requirement in SQL where I need to round off a decimal to a valid currency denomination. Examples are as follows...
Input - Output
68.40 - 68.40
68.41 - 68.40
68.42 - 68.40
68.43 - 68.45
68.44 - 68.45
68.45 - 68.45
68.46 - 68.45
68.47 - 68.45
68.48 - 68.50
68.49 - 68.50
68.50 - 68.50
Is there any scalar function available, by manipulating which I can get my required output.
I need another information. Is there a way to grant permission on all the tables in a database to some one. For one table, I am using the following command.
Code: | GRANT ALL ON FE.SYSTM_GLBL_READ TO USERID ;
COMMIT ; |
Thanks in advance...
Sridhar P |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
|
|