Equivalent to time datatype in DB2???

Jake K · #1 (**permalink**) 03-01-04, 05:48

hi friends,

do anyone know the equivalent datatype in SQL server to 'time' datatype in DB2? For your information, 'time' datatype allows to store only hh:mm:ss.

Appreciate your help.

Jake

sathyaram_s · #2 (**permalink**) 03-01-04, 05:58

Please read the SQL Reference for your platform and version ...

Cheers
Sathyaram

Quote:

Originally posted by Jake K
hi friends,

do anyone know the equivalent datatype in SQL server to 'time' datatype in DB2? For your information, 'time' datatype allows to store only hh:mm:ss.

Appreciate your help.

Jake

Jake K · #3 (**permalink**) 03-01-04, 07:01

Quote:

Originally posted by sathyaram_s
Please read the SQL Reference for your platform and version ...

Cheers
Sathyaram

thanks for the quick reply. i think i'm not clear in my previous mail. I found a datatype named 'time' which allows to store the time in 'hh:mm:ss' format. I am using DB2 UDB 8.1. I like to know the equivalent to this in the MSSQL server 2000, since i want to do the migration.

Jake

Internet Services

Web Development

Digital Marketing

Consumer Tech