Filetime

How can I convert filetime to datetime in sql server inside a sored procedure.
Thanks
BVR
"uhway" <uhway@.discussions.microsoft.com> wrote in message
news:B53A17CF-BFE1-4B37-8D0E-466859C445C8@.microsoft.com...
> How can I convert filetime to datetime in sql server inside a sored
> procedure.
> Thanks
> BVR
What do you mean by filetime? Can you give an example of what the filetime
data looks like?
Rick Sawtell
MCT, MCSD, MCDBA
|||Filetime is a 64 bit number representing time(up to nano seconds) from
January 1, 1601 to what ever the time right now.
In C++/C# etc, you have functions to get his value or to convert file time
in system time. Ex;: Getfiletime()
FileTime 127512288251260000 is equivalent to '2005/01/26 16:00:25.126'
"Rick Sawtell" wrote:

> "uhway" <uhway@.discussions.microsoft.com> wrote in message
> news:B53A17CF-BFE1-4B37-8D0E-466859C445C8@.microsoft.com...
>
> What do you mean by filetime? Can you give an example of what the filetime
> data looks like?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>