Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Fields? in a table

Status
Not open for further replies.

SMCmtg

Programmer
Mar 27, 2000
90
US
General question. . .how are dates stored in the raw table field as "date" 8?
Does it store a Julian or a numeric or a string or characters or intergars or what? What is it actually saving , realizing "Dates" can be used in a 100 different ways.
Thx for any feedback or commentary
 
THEY ARE STORED AS RAW DATA YYYYMMDD IN A DATE FIELD.
TESTING....
CREATE A TABLE WITH TEST AS DATE FIELD AND SAVE A TEST1.
INPUT DATA 22/12/2001 {BRITISH DATE FOR EXAMPLE)
THEN SAVE AND QUIT
GO TO THE PROMPT AND TYPE TEST.DBF. YOU CAN SEE THE DATE STORED IN YYYYMMDD FORMAT.
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
 
Datetime field, however, contains date in the new format (double number).
Vlad Grynchyshyn
vgryn@softserve.lviv.ua
The professional level of programmer could be determined by level of stupidity of his/her bugs
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top