. Floating points A floating-point (Web design) number is just as
. Floating points A floating-point number is just as the name implies, where the decimal point floats freely anywhere within the number. In other words, the decimal point can appear anywhere in the number. Floating-point values can have any number of digits both before and after the decimal point, even none on either side. Values such as 1000, 1000.12345, and 0.8843343223 are valid floating-point numbers. Floating point values are likely to be less efficient in storage and retrieval than fixed-length decimals and integers because they are less predictable in terms of record length and otherwise. Figure 3-7 shows a 32-byte length floating-point datatype and a relatively unlimited length floating point datatype. For most databases, any INSERT commands into the float fields exceeding length requirements (such as 32 bytes for SFLT) will not produce errors because values added will likely be truncated and converted to exponential (scientific) notation when too large or too small, as shown in Figure 3-8. Figure 3-8: Adding values to floating-point datatype fields. . Dates and times Dates can be stored as simple dates or dates including timestamp information. In actuality, simple dates are often stored as a Julian date or some other similar numbering system. A Julian date is a time in seconds from a specified start date (such as January 1, 1960). When simple date values are set or retrieved in the database, they are subjected to a default formatting process spitting out to, for example, a dd/mm/yyyy format excluding seconds (depending on default database formatting settings, of course). A timestamp datatype displays both date and time information regardless of any default date formatting executing in the database (sometimes stored as a special timestamp datatype). Figure 3-9 shows the difference between dates with timestamps and dates without timestamps. insert into numbers(sflt) values(5.2234); SQL> select sflt from numbers; SFLT 5 60000 4.0000E+20 .000005 insert into numbers(sflt) values(55444); insert into numbers(sflt) values(449998234590782340895); insert into numbers(sflt) values(0.0000049998234590782340895); 45 Database Modeling Building Blocks
Note: If you are looking for cheap webhost to host and run your apache application check Vision apache web hosting services