Subject | Re: How to split a number |
---|---|

Author | apatri@inwind.it |

Post date | 2001-02-13T15:50:38Z |

HI.

Solved. Very deep thanks to Svein and Ann.

Arnaldo

--- In ib-support@y..., Svein Erling Tysvær

<svein.erling.tysvaer@k...> wrote:

Solved. Very deep thanks to Svein and Ann.

Arnaldo

--- In ib-support@y..., Svein Erling Tysvær

<svein.erling.tysvaer@k...> wrote:

> SELECT CAST(<number>-0.5 as Integer)subtract

> FROM <table>

>

> Cast rounds to the nearest whole number, to truncate you have to

> 0,5 (if not 5,75 would end up as 6).Delphi?

>

> Set

>

> At 14:43 13.02.2001 -0000, you wrote:

> >Hi All.

> >Again here.

> >

> >Please list:

> >How to extract the integer part of a numeric field??????

> >

> >eg:

> >If I have let say: 5,75

> >I'd like to split in 5 and 0,75.

> >Final: What is( if exist ) the equivalent of int and frac of

> >

> >TIA

> >Arnaldo

>

> Sorry for the below advert - I didn't insert it ;o}