Not getting milliseconds from database

Question

0.00/5 (No votes)

See more:

Hi all,

I am calling a list stored procedure using c#. This sp return a dataset. the Tables in dataset hava datetime columns. But in that column values not getting milliseconds even value contain milliseconds in database. How to get datatable with milliseconds.

Posted 16-Oct-12 21:07pm

Narra sreenu

Updated 16-Oct-12 22:22pm

v2

Add a Solution

Comments

Sushil Mate 17-Oct-12 3:13am

Does the database has date time column in milliseconds?

Narra sreenu 17-Oct-12 4:21am

yes

Sushil Mate 17-Oct-12 4:24am

can you show us your stored procedure?

Narra sreenu 17-Oct-12 4:31am

If sp executes in DataBase datatable displayed as:

UserId UserName FirstName LastName CreatedOn
146 adarshbandi Adarsh Bandi 2012-10-13 13:30:11.563

If sp executes in c# Datatable displayed as:

UserId UserName FirstName LastName CreatedOn
146 adarshbandi Adarsh Bandi 2012-10-13 13:30:11 PM

Narra sreenu 17-Oct-12 4:36am

ALTER PROCEDURE [dbo].[sp_TypingTutor_Admin_Granted_UsersList]
AS
BEGIN
select UserId,UserName,

FirstName,
LastName,

cast(DateofBirth as smalldatetime) as 'Date of Birth',

LastUpdatedOn as 'CreatedOn' from users where usertype=2 and userid is not NULL and deletedyn=0
end

Sushil Mate 17-Oct-12 5:23am

check my solution :)
Hope it helps.

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

damodara naidu betha · Answer 1 · 2012-10-16T21:12:00

Solution 1

try this code in your application...

format(dr["DateValue"].ToString(), "dd mmm yyyy hh:nn:ss.fff") to get milliseconds

Thank you

Posted 16-Oct-12 21:12pm

damodara naidu betha

Code-Hunt · Answer 2 · 2012-10-16T21:49:00

Solution 2

u can use DATEPART() for this..check example for this

http://www.w3schools.com/sql/func_datepart.asp[^]

Posted 16-Oct-12 21:49pm

Code-Hunt

VIPR@T · Answer 3 · 2012-10-16T22:44:00

Solution 3

Hi,

See the below link. It might be help you to find the solution.

http://www.csharp-examples.net/string-format-datetime/[^]

Thanks,
Viprat

Posted 16-Oct-12 22:44pm

VIPR@T

Sushil Mate · Answer 4 · 2012-10-16T23:23:00

Solution 4

SQL

ALTER PROCEDURE [dbo].[sp_TypingTutor_Admin_Granted_UsersList]
AS 
BEGIN
	select UserId,UserName,
			FirstName,
			LastName,
			DateofBirth as 'Date of Birth',
			LastUpdatedOn as 'CreatedOn' from users where usertype=2 and userid is not NULL and deletedyn=0

END

Posted 16-Oct-12 23:23pm

Sushil Mate

Bhis · Answer 5 · 2014-07-30T12:35:00

The data Table has milliseconds, if you check data row item array. You'll have to change the string format to your need.

Here is an example passing it to SQL string:

C#

strSql.AppendFormat(" EventDate = '{0}' AND", String.Format("{0:MM/dd/yyyy HH:mm:ss.fff}", dr[EventDate]));

This link has all the formats in detail:
http://www.csharp-examples.net/string-format-datetime/[^]