Time stamp

How do you convert a time stamp into actual date in SQL
When we try to convert it, date that we get doesn't make sense (date we
supposed to get is like year 2001, but date seem to be very very old)
MC

Unfortunately the name of the Timestamp data type is misleading - it has
nothing to do with time. Check th data type in Books OnLine, or check, for
example, http://www.sqlteam.com/item.asp?ItemID=1410.

--
Dejan Sarka, SQL Server MVP
Mentor, www. SolidQualityLearning
.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

"MC" <webmaster@ozoptics.com> wrote in message
news:%23UFNaP2TGHA.4452@TK2MSFTNGP12.phx.gbl...
> How do you convert a time stamp into actual date in SQL
> When we try to convert it, date that we get doesn't make sense (date we
> supposed to get is like year 2001, but date seem to be very very old)
> MC
>
>

Mmm, what we are trying to do is impossible then
(Deleting records on a table based on date, where there is no date and time
fields)
MC

"Dejan Sarka" < dejan_please_reply_t
o_newsgroups.sarka@avtenta.si> wrote in
message news:#bhxlk2TGHA.4276@TK2MSFTNGP10.phx.gbl...
> Unfortunately the name of the Timestamp data type is misleading - it has
> nothing to do with time. Check th data type in Books OnLine, or check, for
> example, http://www.sqlteam.com/item.asp?ItemID=1410.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www. SolidQualityLearning
.com
> Anything written in this message represents solely the point of view of
the
> sender.
> This message does not imply endorsement from Solid Quality Learning, and
it
> does not represent the point of view of Solid Quality Learning or any
 other

> person, company or institution mentioned in this message
>
> "MC" <webmaster@ozoptics.com> wrote in message
> news:%23UFNaP2TGHA.4452@TK2MSFTNGP12.phx.gbl... 
>
>