datetime field conversion

Last Post 04 Mar 2006 08:58 PM by khtan. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
trans53
New Member
New Member

--
27 Jan 2006 08:58 AM
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?

Thanks
trans53
New Member
New Member

--
27 Jan 2006 11:59 AM
thank you
khtan
New Member
New Member

--
04 Mar 2006 08:58 PM
quote:

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?

Thanks


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 !.
You are not authorized to post a reply.

Acceptable Use Policy