What is the datatype to record time ? if a datatype exists does it work in Oracle 8?
Smoove.

Each database has a version of Date/Time ... Which one are you interested in?

i'm intersted this topic..what is the datatype for time Using Mssql server database.?please..

i'm intersted this topic..what is the datatype for time Using Mssql server database.?please..

There is timestamp, date and datetime data types

http://dev.mysql.com/doc/mysql/en/DATETIME.html

And you can read about functions for working with these types here

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

But be aware that some functions are only avaliable as of a particular version of MySQL (often 4.1). And the latest 'production' relase of MySQL is 4.0.21.