datetime seconds

[Chuck Hecht]

I have a field defined as a datetime but it will not let me display seconds
only minutes?

 

[Guest]

What do you mean by "field"? Show us the code you're currently using to
display the time.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com

 

[Chuck Hecht]

I have a Sql Server Compact Edition (3.1) database with a Column named
Timestamp, defined as a datatime data type. If I enter a value like
DD/MM/YYYY hh:mm:ss ( 07/09/2007 12:25:15) it removes the seconds and the
value is 07/09/2007 12:25

 

[Guest]

How are you "entering" the datetime value? How are you displaying back out
to verify the data loss?


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com

 

[Chuck Hecht]

In VS2005 open server explorer, create a connection to my database. Right
click on my table, select open now I can enter data into each field

 

[Guest]

Alter your table and define the column as a timestamp. Everything else
should work the same. If using code to add/update the columne, ensure you
define the parameters as a timestamp.

Rick D.
Contractor

In VS2005 open server explorer, create a connection to my database. Right
click on my table, select open now I can enter data into each field

How are you "entering" the datetime value? How are you displaying back
out to verify the data loss?


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com

I have a Sql Server Compact Edition (3.1) database with a Column named
Timestamp, defined as a datatime data type. If I enter a value like
DD/MM/YYYY hh:mm:ss ( 07/09/2007 12:25:15) it removes the seconds and the
value is 07/09/2007 12:25

"<ctacke/>" <ctacke[at]opennetcf[dot]com> wrote in message
What do you mean by "field"? Show us the code you're currently using to
display the time.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com


I have a field defined as a datetime but it will not let me display
seconds only minutes?

 

[Guest]

The datetime field can certainly hold seconds (as well as milliseconds). My
guess is that it's a formatting issue. You might try using code to extract
the value and look at it.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com

In VS2005 open server explorer, create a connection to my database. Right
click on my table, select open now I can enter data into each field

How are you "entering" the datetime value? How are you displaying back
out to verify the data loss?


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com

I have a Sql Server Compact Edition (3.1) database with a Column named
Timestamp, defined as a datatime data type. If I enter a value like
DD/MM/YYYY hh:mm:ss ( 07/09/2007 12:25:15) it removes the seconds and the
value is 07/09/2007 12:25

"<ctacke/>" <ctacke[at]opennetcf[dot]com> wrote in message
What do you mean by "field"? Show us the code you're currently using
to display the time.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com


I have a field defined as a datetime but it will not let me display
seconds only minutes?