|
Home > Archive > MS SQL Server Tools > March 2006 > Time stamp
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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 2006-03-24, 8:25 pm |
| 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...
>
>
|
|
|
|
|