473,385 Members | 1,582 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Error converting FILETIME to DateTime

Hi,
it should be simple,
put FILETIME in a Long
conver it in date using the DateTime.FromFileTimeUtc

The help even says: Converts the specified Windows file time to an
equivalent UTC time.
Now why happens this:
original filetime 21/02/2006 00:33:29

bytes:
80 C2 E6 AB
6D 36 C6 01

when I convert it I have:
1) 20/02/2006 22:26:19
2) 20/02/2006 22:26:19

Code:
Dim ad3 As System.DateTime
Dim aLn1 As Long
Dim ad1 As System.Runtime.InteropServices.ComTypes.FILETIME

ad1.dwHighDateTime = &H1C6366D
ad1.dwLowDateTime = &HABE6C280

aLn1 = (CLng(ad1.dwHighDateTime) << 32) + CLng(ad1.dwLowDateTime)

ad3 = DateTime.FromFileTimeUtc(aLn1)
Debug.Print("1) " & ad3)
ad3.ToLocalTime()
Debug.Print("2) " & ad3)

and even worst if I do:
ad3 = CDate("21/02/2006 00:33:29")

the Thicks property is equal to:
ad3.Ticks &H8C8049591E69280 Long
please can anyone help me?

Thanks,
M.
Jun 10 '06 #1
14 9397
msAvazzi,

What is it what you want to achieve, there are so many methods in datetime
that I am not seeing what your goal is. I gues that is the same for others.

By instance
http://msdn.microsoft.com/library/de...ssaddtopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:50**********************************@microsof t.com...
Hi,
it should be simple,
put FILETIME in a Long
conver it in date using the DateTime.FromFileTimeUtc

The help even says: Converts the specified Windows file time to an
equivalent UTC time.
Now why happens this:
original filetime 21/02/2006 00:33:29

bytes:
80 C2 E6 AB
6D 36 C6 01

when I convert it I have:
1) 20/02/2006 22:26:19
2) 20/02/2006 22:26:19

Code:
Dim ad3 As System.DateTime
Dim aLn1 As Long
Dim ad1 As System.Runtime.InteropServices.ComTypes.FILETIME

ad1.dwHighDateTime = &H1C6366D
ad1.dwLowDateTime = &HABE6C280

aLn1 = (CLng(ad1.dwHighDateTime) << 32) + CLng(ad1.dwLowDateTime)

ad3 = DateTime.FromFileTimeUtc(aLn1)
Debug.Print("1) " & ad3)
ad3.ToLocalTime()
Debug.Print("2) " & ad3)

and even worst if I do:
ad3 = CDate("21/02/2006 00:33:29")

the Thicks property is equal to:
ad3.Ticks &H8C8049591E69280 Long
please can anyone help me?

Thanks,
M.

Jun 11 '06 #2
Cor,
I have a FILETIME (that I read from a File) and I want to store it in a
DateTime variable.

And I do agree with you, it has a lot of methods.

Unluckily it looks like THEY DON'T WORK (or is not clear how to have them
work).
If you try the code I've posted you'll see.

here is tha MSDN reference:
http://msdn.microsoft.com/library/en...asp?frame=true

M

"Cor Ligthert [MVP]" wrote:
msAvazzi,

What is it what you want to achieve, there are so many methods in datetime
that I am not seeing what your goal is. I gues that is the same for others.

By instance
http://msdn.microsoft.com/library/de...ssaddtopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:50**********************************@microsof t.com...
Hi,
it should be simple,
put FILETIME in a Long
conver it in date using the DateTime.FromFileTimeUtc

The help even says: Converts the specified Windows file time to an
equivalent UTC time.
Now why happens this:
original filetime 21/02/2006 00:33:29

bytes:
80 C2 E6 AB
6D 36 C6 01

when I convert it I have:
1) 20/02/2006 22:26:19
2) 20/02/2006 22:26:19

Code:
Dim ad3 As System.DateTime
Dim aLn1 As Long
Dim ad1 As System.Runtime.InteropServices.ComTypes.FILETIME

ad1.dwHighDateTime = &H1C6366D
ad1.dwLowDateTime = &HABE6C280

aLn1 = (CLng(ad1.dwHighDateTime) << 32) + CLng(ad1.dwLowDateTime)

ad3 = DateTime.FromFileTimeUtc(aLn1)
Debug.Print("1) " & ad3)
ad3.ToLocalTime()
Debug.Print("2) " & ad3)

and even worst if I do:
ad3 = CDate("21/02/2006 00:33:29")

the Thicks property is equal to:
ad3.Ticks &H8C8049591E69280 Long
please can anyone help me?

Thanks,
M.


Jun 11 '06 #3
And you tried this as well?

http://msdn.microsoft.com/library/de...meUtcTopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:BA**********************************@microsof t.com...
Cor,
I have a FILETIME (that I read from a File) and I want to store it in a
DateTime variable.

And I do agree with you, it has a lot of methods.

Unluckily it looks like THEY DON'T WORK (or is not clear how to have them
work).
If you try the code I've posted you'll see.

here is tha MSDN reference:
http://msdn.microsoft.com/library/en...asp?frame=true

M

"Cor Ligthert [MVP]" wrote:
msAvazzi,

What is it what you want to achieve, there are so many methods in
datetime
that I am not seeing what your goal is. I gues that is the same for
others.

By instance
http://msdn.microsoft.com/library/de...ssaddtopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:50**********************************@microsof t.com...
> Hi,
> it should be simple,
> put FILETIME in a Long
> conver it in date using the DateTime.FromFileTimeUtc
>
> The help even says: Converts the specified Windows file time to an
> equivalent UTC time.
>
>
> Now why happens this:
> original filetime 21/02/2006 00:33:29
>
> bytes:
> 80 C2 E6 AB
> 6D 36 C6 01
>
> when I convert it I have:
> 1) 20/02/2006 22:26:19
> 2) 20/02/2006 22:26:19
>
> Code:
> Dim ad3 As System.DateTime
> Dim aLn1 As Long
> Dim ad1 As System.Runtime.InteropServices.ComTypes.FILETIME
>
> ad1.dwHighDateTime = &H1C6366D
> ad1.dwLowDateTime = &HABE6C280
>
> aLn1 = (CLng(ad1.dwHighDateTime) << 32) +
> CLng(ad1.dwLowDateTime)
>
> ad3 = DateTime.FromFileTimeUtc(aLn1)
> Debug.Print("1) " & ad3)
> ad3.ToLocalTime()
> Debug.Print("2) " & ad3)
>
> and even worst if I do:
> ad3 = CDate("21/02/2006 00:33:29")
>
> the Thicks property is equal to:
> ad3.Ticks &H8C8049591E69280 Long
>
>
> please can anyone help me?
>
> Thanks,
> M.


Jun 11 '06 #4
Cor,
If I understood correctly it should be the function I'm using:
ad3 = DateTime.FromFileTimeUtc(aLn1)
Or I'm doing something wrong?

M

"Cor Ligthert [MVP]" wrote:
And you tried this as well?

http://msdn.microsoft.com/library/de...meUtcTopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:BA**********************************@microsof t.com...
Cor,
I have a FILETIME (that I read from a File) and I want to store it in a
DateTime variable.

And I do agree with you, it has a lot of methods.

Unluckily it looks like THEY DON'T WORK (or is not clear how to have them
work).
If you try the code I've posted you'll see.

here is tha MSDN reference:
http://msdn.microsoft.com/library/en...asp?frame=true

M

"Cor Ligthert [MVP]" wrote:
msAvazzi,

What is it what you want to achieve, there are so many methods in
datetime
that I am not seeing what your goal is. I gues that is the same for
others.

By instance
http://msdn.microsoft.com/library/de...ssaddtopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:50**********************************@microsof t.com...
> Hi,
> it should be simple,
> put FILETIME in a Long
> conver it in date using the DateTime.FromFileTimeUtc
>
> The help even says: Converts the specified Windows file time to an
> equivalent UTC time.
>
>
> Now why happens this:
> original filetime 21/02/2006 00:33:29
>
> bytes:
> 80 C2 E6 AB
> 6D 36 C6 01
>
> when I convert it I have:
> 1) 20/02/2006 22:26:19
> 2) 20/02/2006 22:26:19
>
> Code:
> Dim ad3 As System.DateTime
> Dim aLn1 As Long
> Dim ad1 As System.Runtime.InteropServices.ComTypes.FILETIME
>
> ad1.dwHighDateTime = &H1C6366D
> ad1.dwLowDateTime = &HABE6C280
>
> aLn1 = (CLng(ad1.dwHighDateTime) << 32) +
> CLng(ad1.dwLowDateTime)
>
> ad3 = DateTime.FromFileTimeUtc(aLn1)
> Debug.Print("1) " & ad3)
> ad3.ToLocalTime()
> Debug.Print("2) " & ad3)
>
> and even worst if I do:
> ad3 = CDate("21/02/2006 00:33:29")
>
> the Thicks property is equal to:
> ad3.Ticks &H8C8049591E69280 Long
>
>
> please can anyone help me?
>
> Thanks,
> M.


Jun 11 '06 #5
MsAvazzi,

I would ignore that function because it is one of the few functions not used
anymore in the version 2.0

Cor
"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:D2**********************************@microsof t.com...
Cor,
If I understood correctly it should be the function I'm using:
ad3 = DateTime.FromFileTimeUtc(aLn1)
Or I'm doing something wrong?

M

"Cor Ligthert [MVP]" wrote:
And you tried this as well?

http://msdn.microsoft.com/library/de...meUtcTopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:BA**********************************@microsof t.com...
> Cor,
> I have a FILETIME (that I read from a File) and I want to store it in a
> DateTime variable.
>
> And I do agree with you, it has a lot of methods.
>
> Unluckily it looks like THEY DON'T WORK (or is not clear how to have
> them
> work).
> If you try the code I've posted you'll see.
>
> here is tha MSDN reference:
> http://msdn.microsoft.com/library/en...asp?frame=true
>
>
>
> M
>
> "Cor Ligthert [MVP]" wrote:
>
>> msAvazzi,
>>
>> What is it what you want to achieve, there are so many methods in
>> datetime
>> that I am not seeing what your goal is. I gues that is the same for
>> others.
>>
>> By instance
>> http://msdn.microsoft.com/library/de...ssaddtopic.asp
>>
>> Cor
>>
>> "msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
>> news:50**********************************@microsof t.com...
>> > Hi,
>> > it should be simple,
>> > put FILETIME in a Long
>> > conver it in date using the DateTime.FromFileTimeUtc
>> >
>> > The help even says: Converts the specified Windows file time to an
>> > equivalent UTC time.
>> >
>> >
>> > Now why happens this:
>> > original filetime 21/02/2006 00:33:29
>> >
>> > bytes:
>> > 80 C2 E6 AB
>> > 6D 36 C6 01
>> >
>> > when I convert it I have:
>> > 1) 20/02/2006 22:26:19
>> > 2) 20/02/2006 22:26:19
>> >
>> > Code:
>> > Dim ad3 As System.DateTime
>> > Dim aLn1 As Long
>> > Dim ad1 As System.Runtime.InteropServices.ComTypes.FILETIME
>> >
>> > ad1.dwHighDateTime = &H1C6366D
>> > ad1.dwLowDateTime = &HABE6C280
>> >
>> > aLn1 = (CLng(ad1.dwHighDateTime) << 32) +
>> > CLng(ad1.dwLowDateTime)
>> >
>> > ad3 = DateTime.FromFileTimeUtc(aLn1)
>> > Debug.Print("1) " & ad3)
>> > ad3.ToLocalTime()
>> > Debug.Print("2) " & ad3)
>> >
>> > and even worst if I do:
>> > ad3 = CDate("21/02/2006 00:33:29")
>> >
>> > the Thicks property is equal to:
>> > ad3.Ticks &H8C8049591E69280 Long
>> >
>> >
>> > please can anyone help me?
>> >
>> > Thanks,
>> > M.
>>
>>
>>


Jun 12 '06 #6
"Cor Ligthert [MVP]" <no************@planet.nl> schrieb:
If I understood correctly it should be the function I'm using:
ad3 = DateTime.FromFileTimeUtc(aLn1)


I would ignore that function because it is one of the few functions not
used anymore in the version 2.0


Why not? I don't see that the method is marked as obsolete:

<URL:http://msdn2.microsoft.com/de-de/library/system.datetime.fromfiletimeutc.aspx>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Jun 12 '06 #7
Herfried,

For this reason I look forever only on the English language website.

http://msdn.microsoft.com/library/de...meUtcTopic.asp

This link was already given by msAvazzi, otherwise I would not have know
this.

Folglich kannst du zur deutschen Seite wieder ein wenig notieren.

Warum du, richtig.
:-)
Cor
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> schreef in bericht
news:ud****************@TK2MSFTNGP05.phx.gbl...
"Cor Ligthert [MVP]" <no************@planet.nl> schrieb:
If I understood correctly it should be the function I'm using:
ad3 = DateTime.FromFileTimeUtc(aLn1)


I would ignore that function because it is one of the few functions not
used anymore in the version 2.0


Why not? I don't see that the method is marked as obsolete:

<URL:http://msdn2.microsoft.com/de-de/library/system.datetime.fromfiletimeutc.aspx>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Jun 12 '06 #8
"Cor Ligthert [MVP]" <no************@planet.nl> schrieb:
For this reason I look forever only on the English language website.

http://msdn.microsoft.com/library/de...meUtcTopic.asp


Well, that's the documentation of .NET 1.1 and the page simply states that
this member is not supported by .NET *1.0*!

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Jun 12 '06 #9
Herfried,

You are right,

It means that the English documentation is not up to date but the German one
is.
I was already disapointed about this breaking change.
:-)

Cor

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> schreef in bericht
news:O2**************@TK2MSFTNGP02.phx.gbl...
"Cor Ligthert [MVP]" <no************@planet.nl> schrieb:
For this reason I look forever only on the English language website.

http://msdn.microsoft.com/library/de...meUtcTopic.asp


Well, that's the documentation of .NET 1.1 and the page simply states that
this member is not supported by .NET *1.0*!

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Jun 12 '06 #10
Cor,

"Cor Ligthert [MVP]" <no************@planet.nl> schrieb:
It means that the English documentation is not up to date but the German
one is.
I was already disapointed about this breaking change.


There is a .NET 2.0 version of the documentation available too:

<URL:http://msdn2.microsoft.com/en-us/library/system.datetime.fromfiletimeutc.aspx>

Note the "msdn2" instead of the "msdn"!

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Jun 12 '06 #11
Herfried,

You are again right, normally I would have found that as well as first, but
now was I using the by the OP supported link. This is of course not good as
documentation. We know that MSDN2 from expirience.

Cor

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> schreef in bericht
news:uO**************@TK2MSFTNGP02.phx.gbl...
Cor,

"Cor Ligthert [MVP]" <no************@planet.nl> schrieb:
It means that the English documentation is not up to date but the German
one is.
I was already disapointed about this breaking change.


There is a .NET 2.0 version of the documentation available too:

<URL:http://msdn2.microsoft.com/en-us/library/system.datetime.fromfiletimeutc.aspx>

Note the "msdn2" instead of the "msdn"!

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Jun 12 '06 #12
MSAvazzi,

With all those discussions you would not understand it anymore therefore.

This gives for me the creation date in UTC time which is at my place 2 hours
before the current time.

\\\
Dim fi As New IO.FileInfo("c:\test.txt")
Dim dt As New DateTime(fi.CreationTimeUtc.Ticks)
MessageBox.Show(dt.ToString)
///

I hope this helps,

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:D2**********************************@microsof t.com...
Cor,
If I understood correctly it should be the function I'm using:
ad3 = DateTime.FromFileTimeUtc(aLn1)
Or I'm doing something wrong?

M

"Cor Ligthert [MVP]" wrote:
And you tried this as well?

http://msdn.microsoft.com/library/de...meUtcTopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:BA**********************************@microsof t.com...
> Cor,
> I have a FILETIME (that I read from a File) and I want to store it in a
> DateTime variable.
>
> And I do agree with you, it has a lot of methods.
>
> Unluckily it looks like THEY DON'T WORK (or is not clear how to have
> them
> work).
> If you try the code I've posted you'll see.
>
> here is tha MSDN reference:
> http://msdn.microsoft.com/library/en...asp?frame=true
>
>
>
> M
>
> "Cor Ligthert [MVP]" wrote:
>
>> msAvazzi,
>>
>> What is it what you want to achieve, there are so many methods in
>> datetime
>> that I am not seeing what your goal is. I gues that is the same for
>> others.
>>
>> By instance
>> http://msdn.microsoft.com/library/de...ssaddtopic.asp
>>
>> Cor
>>
>> "msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
>> news:50**********************************@microsof t.com...
>> > Hi,
>> > it should be simple,
>> > put FILETIME in a Long
>> > conver it in date using the DateTime.FromFileTimeUtc
>> >
>> > The help even says: Converts the specified Windows file time to an
>> > equivalent UTC time.
>> >
>> >
>> > Now why happens this:
>> > original filetime 21/02/2006 00:33:29
>> >
>> > bytes:
>> > 80 C2 E6 AB
>> > 6D 36 C6 01
>> >
>> > when I convert it I have:
>> > 1) 20/02/2006 22:26:19
>> > 2) 20/02/2006 22:26:19
>> >
>> > Code:
>> > Dim ad3 As System.DateTime
>> > Dim aLn1 As Long
>> > Dim ad1 As System.Runtime.InteropServices.ComTypes.FILETIME
>> >
>> > ad1.dwHighDateTime = &H1C6366D
>> > ad1.dwLowDateTime = &HABE6C280
>> >
>> > aLn1 = (CLng(ad1.dwHighDateTime) << 32) +
>> > CLng(ad1.dwLowDateTime)
>> >
>> > ad3 = DateTime.FromFileTimeUtc(aLn1)
>> > Debug.Print("1) " & ad3)
>> > ad3.ToLocalTime()
>> > Debug.Print("2) " & ad3)
>> >
>> > and even worst if I do:
>> > ad3 = CDate("21/02/2006 00:33:29")
>> >
>> > the Thicks property is equal to:
>> > ad3.Ticks &H8C8049591E69280 Long
>> >
>> >
>> > please can anyone help me?
>> >
>> > Thanks,
>> > M.
>>
>>
>>


Jun 12 '06 #13
Cor,
you've been very kind.

Can you please try this code? because I'm getting mad....
Dim dt As New DateTime(&H1C6366CABE6C280)
MessageBox.Show(dt.ToString)
ad3 = CDate("21/02/2006 00:33:29")
MessageBox.Show(dt.Ticks)

I get a meaningless 20/02/0406 22:26:19
(ok this is equal to my code, exactly the same wrong date)
while if I use all other programs (i.e. AXE 3)
I got: 2006/02/21 00:33:29
that is the right information.

the funny thing is that the Ticks of the right date are:
ad3.Ticks &H8C8049591E69280 Long

So it looks like that "old" ticks are different from new ones!
I realy don't understand
"Cor Ligthert [MVP]" wrote:
MSAvazzi,

With all those discussions you would not understand it anymore therefore.

This gives for me the creation date in UTC time which is at my place 2 hours
before the current time.

\\\
Dim fi As New IO.FileInfo("c:\test.txt")
Dim dt As New DateTime(fi.CreationTimeUtc.Ticks)
MessageBox.Show(dt.ToString)
///

I hope this helps,

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:D2**********************************@microsof t.com...
Cor,
If I understood correctly it should be the function I'm using:
ad3 = DateTime.FromFileTimeUtc(aLn1)
Or I'm doing something wrong?

M

"Cor Ligthert [MVP]" wrote:
And you tried this as well?

http://msdn.microsoft.com/library/de...meUtcTopic.asp

Cor

"msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
news:BA**********************************@microsof t.com...
> Cor,
> I have a FILETIME (that I read from a File) and I want to store it in a
> DateTime variable.
>
> And I do agree with you, it has a lot of methods.
>
> Unluckily it looks like THEY DON'T WORK (or is not clear how to have
> them
> work).
> If you try the code I've posted you'll see.
>
> here is tha MSDN reference:
> http://msdn.microsoft.com/library/en...asp?frame=true
>
>
>
> M
>
> "Cor Ligthert [MVP]" wrote:
>
>> msAvazzi,
>>
>> What is it what you want to achieve, there are so many methods in
>> datetime
>> that I am not seeing what your goal is. I gues that is the same for
>> others.
>>
>> By instance
>> http://msdn.microsoft.com/library/de...ssaddtopic.asp
>>
>> Cor
>>
>> "msavazzi" <m.*******@discussion.microsoft.com> schreef in bericht
>> news:50**********************************@microsof t.com...
>> > Hi,
>> > it should be simple,
>> > put FILETIME in a Long
>> > conver it in date using the DateTime.FromFileTimeUtc
>> >
>> > The help even says: Converts the specified Windows file time to an
>> > equivalent UTC time.
>> >
>> >
>> > Now why happens this:
>> > original filetime 21/02/2006 00:33:29
>> >
>> > bytes:
>> > 80 C2 E6 AB
>> > 6D 36 C6 01
>> >
>> > when I convert it I have:
>> > 1) 20/02/2006 22:26:19
>> > 2) 20/02/2006 22:26:19
>> >
>> > Code:
>> > Dim ad3 As System.DateTime
>> > Dim aLn1 As Long
>> > Dim ad1 As System.Runtime.InteropServices.ComTypes.FILETIME
>> >
>> > ad1.dwHighDateTime = &H1C6366D
>> > ad1.dwLowDateTime = &HABE6C280
>> >
>> > aLn1 = (CLng(ad1.dwHighDateTime) << 32) +
>> > CLng(ad1.dwLowDateTime)
>> >
>> > ad3 = DateTime.FromFileTimeUtc(aLn1)
>> > Debug.Print("1) " & ad3)
>> > ad3.ToLocalTime()
>> > Debug.Print("2) " & ad3)
>> >
>> > and even worst if I do:
>> > ad3 = CDate("21/02/2006 00:33:29")
>> >
>> > the Thicks property is equal to:
>> > ad3.Ticks &H8C8049591E69280 Long
>> >
>> >
>> > please can anyone help me?
>> >
>> > Thanks,
>> > M.
>>
>>
>>


Jun 13 '06 #14
Msavazi,

Can you please try this code? because I'm getting mad....
Dim dt As New DateTime(&H1C6366CABE6C280)
MessageBox.Show(dt.ToString)
ad3 = CDate("21/02/2006 00:33:29")
MessageBox.Show(dt.Ticks)


No, there are so many datetime formats that I have stopped to look at any
internal format of them.

It gives me only troubles I cannot solve.

Sorry

Cor

Jun 14 '06 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Justin Wong | last post by:
CREATE PROCEDURE dbo.Synchronization_GetNewRecords ( @item varchar(50), @last datetime ) AS SET NOCOUNT ON
11
by: jguilford | last post by:
I have created a SQL Stored Procedure that uses a Case statement to determine the Order By. For one of the Case statements I am trying to turn a Char field into Datetime in for the Order By,...
4
by: Saso Zagoranski | last post by:
Hi! I have created an SqlCommand object and I have set some parameters to it... One of the parameters is of the DateTime type; here is the code: sqlCommand.Parameters.Value =...
5
by: rodri rodri via DotNetMonster.com | last post by:
I have done a program with windows forms in "Visual C++". I have implemented a function that returns two values. For example: double functionExample(int parameter, double __gc* result2); And...
1
by: aunthas | last post by:
I want to play sound using winapi, so I wrote these lines of code:- ------------------------------------------------------------------------------------------------------------------- using...
1
by: Andrew Baker | last post by:
this seems to be an SQL Server error but I cant work out how it is occuring. Itr is also after 3am and I cant keep working but need to demo by tomorrow. TIA. The code is: Private Sub...
1
by: Sneil | last post by:
I know, general answer for my question is: long hFT2 = (((long) ft.dwHighDateTime) << 32) + ft.dwLowDateTime; DateTime dte = DateTime.FromFileTimeUtc(hFT2); where dwHighDateTime/dwLowDateTime...
2
by: joyjignesh | last post by:
hi i have make a report with mshflexgrid. the report between two date. when i have written query .open"select * from tablename where t_date>=convert(datetime,' " & text1.text &"') and ...
1
by: SnehaAgrawal | last post by:
Hi I get the error "Syntax error converting datetime from character string "for the following sql statement in Stored proc. SET @dynamicSQL =N'SELECT CUSTID,SHCodeLink FROM AccountMaster where...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.