Originally posted by: trans53
Hi, i was wondering if it is possible to convert data from the DATETIME field into INT datatype and also from char(1) into bit?
Why do you want to use Integer data type for storage of date and / or time. Leave it as datetime instead. It is much easier to handle date & time in datatime field rather than in integer or varchar. datetime data type is there for storage of date & time, use it !.