DateTime Conversion

[evint]

Folks,
I have created a DataTable containing a column, FilterOn, using the
DateTime type:
col = tbl.Columns.Add("FilterOn", GetType(DateTime))

While attempting to store a value of #12:00:00 AM# I observed that
what actually gets stored is the "Default Date" of 1/1/0001, without
the time. Apparently this happens because the .NET Framework and COM
assume a default date when only a time is specified.

There are frequent occasions when I only want to store 12:00:00 AM
in the field, without any date. Is there a propery or method, etc that
I can use to make this happen? This table is being used to insert
records into an Access database. The Access database has gobs of these
type dates.

Thanks,
Vint

 

[Cor Ligthert [MVP]]

Evint,

You cannot and it gives you no advantage if you could.
The DateTime is forever stored in the same way.

If you want a time in .Net you can use

datetime.timeofday
http://windowssdk.msdn.microsoft.com/en-us/library/system.datetime.timeofday.aspx

In both .Net and in SQL server the datetime is stored in ticks. However the
format is different and the starting point is different.

I hope this helps,

Cor