meljun cortes byte & number

7/28/2019 MELJUN CORTES Byte & Number

1/32

NUMBER Field Size: BYTE

Description: stores numbers from 0 to 255

no fractions

Decimal precision:None

Storage size: 1 byte

MELJUN CORTES


2/32

NUMBER Field Size: DECIMAL

Description: stores numbers from10^38-1 thru 10^38-1

Decimal precision: 28

Storage size: 12 bytes


3/32

NUMBER Field Size: INTEGER

Description: stores numbers from32,768 to 32,768

no fractions

Decimal precision:None



4/32

NUMBER Field Size: LONG INTEGER

Description: default

stores numbers from2,147,483,648 to

2,147,483,647 no fractions

Decimal precision: None



5/32

NUMBER Field Size: SINGLE

Description: from3.402823E38 to -1.401298E-45 for negative

values

from 1.401298E-45 to 3.402823E38 for positivevalues

Decimal precision:

7Storage size: 4 bytes


6/32

NUMBER Field Size: DOUBLE

Description: stores numbers -1.79769313486231E308 through

-4.94065645841247E-324 for negative values

stores numbers 4.94065645841247E-324 through1.79769313486231E308 for positive values

Decimal precision:

15Storage size: 8 bytes


7/32

NUMBER Field Size: REPLICATION ID

Description:Also referred to as GUID (Globally unique

identifier)

A 16-byte field used to establish a uniqueidentification for replication

Used to identify replicas, replica sets, tables,

records, and other objectsStorage size: 16 bytes


8/32

NUMBER Format: GENERAL NUMBER

Description:default

display the number as enteredData:3456.789

Display:3456.789


9/32

NUMBER Format: CURRENCY

Description:Uses the thousand separator, e.g., a

character that separates units of text or

numberData:

3456.789 -3456.789Display:

$3,456.79 ($3,456.79)


10/32

NUMBER Format: FIXED

Description:Display at least one digit

Data: 3456.789 -3456.789 3.56645

Display:3456.79 -3456.79 3.57


11/32

NUMBER Format: STANDARD

Description:Uses the thousand separator

Data:3456.789

Display:3,456.79


12/32

NUMBER Format: PERCENT

Description:Multiply the value by 100 and append a

percent sign (%)Data:3 0.45

Display:300% 45%


13/32

NUMBER Format: SCIENTIFIC

Description:Uses the standard scientific notation

Data:3456.789

Display:3.46E+03


14/32

DATE/TIME Format:GENERAL DATE

Description:

Default

Combination of Short Date and Longtime

Example

4/3/93, 05:34:00 PM


15/32

DATE/TIME Format:LONG DATE

Description:Same as the Long Date setting in

the Regional Settings Propertiesdialog box in Windows Control

PanelExample

Saturday, April 3, 1993


16/32

DATE/TIME Format:MEDIUM DATE

Description:

Format d-mmm-yy

Example

3-Apr-93


17/32

DATE/TIME Format:SHORT DATE

Description: Same as the Short Date setting in the Regional

Settings Properties dialog box in Windows Control

Panel

Example

4/3/93

Note:

1/1/00 12/31/29 year 2000 to 2029

1/1/30 12/31/99 year 1930 to 1999


18/32

DATE/TIME Format:LONG TIME

Description:

Same as the setting on Time tab inthe Regional Settings Propertiesdialog box in Window Control Panel

Example

5:34:23 PM


19/32

DATE/TIME Format:MEDIUM TIME

Description:

Long time minus the seconds part

Ordinary AM/PM time

Example5:34 PM


20/32

DATE/TIME Format:SHORT TIME

Description:

Military time without the secondspart

Example

17:34


21/32

DATE/TIME Format:CUSTOM FORMAT

: Time separator

/ Date separatorc Same as the General date

predefined format


22/32


d day of the month: 1 to 31

dd day of the month: 01 to 31

ddd 3-letter weekday: Sun to Sat

dddd full name weekday: Sunday

ddddd Short date predefined format

dddddd Long date predefined format


23/32


m month of the year: 1 to 12

mm month of the year: 01 to 12

mmm 3-letter month: Jan to Dec

mmmm full name month: January

w day of the week: 1 to 7

ww week of the year: 1 to 53


24/32


y day of the year: 1 to 366

yy last 2 digits of year: 01 to 99yyyy full year: 0100 to 9999

q quarter of the year: 1 to 4


25/32


h hour: 0 to 23

hh hour: 00 to 23

n minute: 0 to 59

nn minute: 00 to 59

s second: 0 to 59

ss second: 00 to 59


26/32


AM/PM 12-hour uppercase

am/pm 12-hour lowercase

A/P 12-hour uppercase

a/p 12-hour lowercase


27/32


ddd,mmm d,yyyy

Mon,Jun 2,1997

mmmm dd,yyyyJune 02,1997

This is week number ww

This is week number 22Today is dddd

Today is Tuesday


28/32

TEXTand MEMO Format

@ Text character (either a character

or a space) is required

& Text character is not required

< Force all characters to lowercase

> Force all characters to uppercase


29/32

TEXTand MEMO Format

Format Data Display

@@@-@@-@@@@ 465043799 465-04-3799

> davolio

DAVOLIO

Davolio

DAVOLIO

DAVOLIO

DAVOLIO

< davolio

DAVOLIO

Davolio

davolio

davolio

davolio


30/32

INPUT MASK

a property field that allows you toset the form of data you expect therecord to display for a particularfield.


31/32

INPUT MASK

L letter should be entered in the position

A letter or digit must be entered

a optional letter or digit can be enteredC optional character or space

0 digit must be entered

9 optional digit or space

< convert character to lowercase

> convert character to uppercase


32/32

INPUT MASK

:;-/ placeholder or character separator

# digit, space, -, or + sign can be entered

& character or space must be entered

? optional letter can be entered

meljun cortes byte & number

Documents