need code for system date and time

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

hi everyone,

I have a asp.net web application bulid in 3 layer architechure in c#.

I need to read the client system(whoever using ) date and time stored in the stored proc in database.

please help me in coding.

Posted 28-Nov-12 23:50pm

msweety

Add a Solution

Comments

[no name] 29-Nov-12 5:51am

So you want it from Client Side or from Database ??

msweety 29-Nov-12 5:53am

i need from client side..(user's system) which is to be inserted in the database.

2 solutions

Solution 1

Refer this similar thread
How to get the date time of client PC in asp.net C#?[^]

Posted 28-Nov-12 23:58pm

__TR__

Comments

msweety 29-Nov-12 6:03am

thanks for the speedy response.
i am not using any lalbel to dispaly the date and time i just need to read the system date and time to insert into database.

i hope i am clear :-)

__TR__ 29-Nov-12 6:05am

What seems to be the problem?

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)

Krunal Rohit · Accepted Answer · 2012-11-29T00:02:00

Solution 2

All events which happen happen in interaction with the server; and the server knows its local time, which should be got using System.DateTime.UtcNow http://msdn.microsoft.com/en-us/library/system.datetime.utcnow.aspx[^]
On client side, you can use JavaScript method Date.getTimezoneOffset to translate UTC time into local time.. See this turorial : http://www.w3schools.com/jsref/jsref_gettimezoneoffset.asp[^]

Posted 29-Nov-12 0:02am

Krunal Rohit

Comments

msweety 29-Nov-12 6:12am

thanks :-)

i really i didnot get how to use it in my 3 layer architechure.

var d = new Date()
var n = d.getTimezoneOffset();

[no name] 29-Nov-12 6:15am

Acceptance of the solution will be highly appreciated miss .. :)

msweety 29-Nov-12 6:27am

aceepted :-)

now pls explain how to collbrate that code to my 3 layer architechure...

[no name] 29-Nov-12 6:28am

what is your problem exactly ??