Time Field in .dbf

I didn't find a TIME field in .DBF file, but there is a DATE field. How can I enter a time value ??? Is the time endebbed in the date field ???
gianlucaAsked:
Who is Participating?
 
Brendt HessConnect With a Mentor Senior DBACommented:
Sorry -- DBase IV does not have a time field.  You will probably need to save it as a formatted string in a Character field of the appropriate length.
0
 
lluddenCommented:
Depending on the database, time is a subtype of date.

On Access2K, Date is a type double with the time being stored in the decimal part.
0
 
mnyeCommented:
for MS SQL 2000 there is no time field.  its datetime all in one.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Brendt HessSenior DBACommented:
Assuming that your .DBF file is an xBase or FoxPro file, then the Date field is a Date/Time field.  So Yes, Time is embedded in Date.
0
 
gianlucaAuthor Commented:
the .DBF file should be DBIV database and there is no TIME field.
0
 
gianlucaAuthor Commented:
sorry, the .DBF file should be dBASE IV database
0
All Courses

From novice to tech pro — start learning today.