C
Chuck Hecht
I have a field defined as a datetime but it will not let me display seconds
only minutes?
only minutes?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
display the time.
--
Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com
C
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
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
G
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
to verify the data loss?
--
Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com
C
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
click on my table, select open now I can enter data into each field
G
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
should work the same. If using code to add/update the columne, ensure you
define the parameters as a timestamp.
Rick D.
Contractor
Chuck Hecht said: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
Chuck Hecht said: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?
G
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
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
Chuck Hecht said: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
Chuck Hecht said: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?