"MC" <webmas***@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
>
>

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sa***@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" <webmas***@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
> >
> >
>
>