But i can't find the type of date only and not date and time
Can you help me on it?
"Bob Barrows" <com> wrote in message
> The answer is (sort of) in your subject line. Look up the CONVERT function
> in Books Online (BOL).
> Bob Barrows
> PS. You can't store "only the date part" unless you store it as a string.
> BOL has a very good discussion of the datetime datatype.