sql server data warehouse:
Is there a SQL function to get FileTime?
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'
[quoted text, click to view] "Rick Sawtell" wrote:
>
> "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
>
>
>
>
You can use DATEDIFF(ms,startdate, GETDATE())
where ms stands for milliseconds, startdate is a your own starting date, and
getdate is the system function that returns the current date, up to
milliseconds.
Francesco Anti
[quoted text, click to view] "uhway" <uhway@discussions.microsoft.com> wrote in message
news:E0DD2F8B-F244-435D-99A5-105D368AC8D6@microsoft.com...
> Is there a SQL function to get FileTime?
>
> 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...
> > > 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
> >
> >
> >
> >
>
One thing to remember is that since SQL Server DateTime has less reolution,
you can do a direct comparison.
[quoted text, click to view] "Francesco Anti" <fanti @ sicosbt.it> wrote in message
news:ed2YskSBFHA.608@TK2MSFTNGP15.phx.gbl...
> You can use DATEDIFF(ms,startdate, GETDATE())
>
> where ms stands for milliseconds, startdate is a your own starting date,
and
> getdate is the system function that returns the current date, up to
> milliseconds.
>
> Francesco Anti
>
> "uhway" <uhway@discussions.microsoft.com> wrote in message
> news:E0DD2F8B-F244-435D-99A5-105D368AC8D6@microsoft.com...
> > Is there a SQL function to get FileTime?
> >
> > 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...
> > > > 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
> > >
> > >
> > >
> > >
> >
>
>
