how to store a local time in server

Question

0.00/5 (No votes)

See more:

I am Trying to Insert the local Time in Server.But failed to insert

as i want local Time as yyyy-mm-dd HH:mm:ss(24hrs) format.but I am conversion errors

can Anybody Help me..

Thanks in Advance..

Posted 9-Jul-13 1:52am

syedkhaleel

Add a Solution

Comments

Nirav Prabtani 9-Jul-13 7:58am

can you show your code here??

[no name] 9-Jul-13 7:58am

I am using toLacaleString method for formating but it is showing like this m/d/yyyy 5:12:00 PM but i want to string as yyyy-mm-dd HH:mm:ss(24hrs) so i can store in sql server data base

[no name] 9-Jul-13 8:24am

how to get a format yyyy-mm-dd HH:MM:SS(24Hrs) in javascript

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)

Maciej Los · Answer 1 · 2013-07-09T01:58:00

Solution 2

Usually to change date format on SQL server side SET DATEFORMAT[^] command is used.

SQL

SET DATETIMEFORMAT ymd;

INSERT INTO ...

But if you want to get local time on client machine using JavaScript, see this:
http://stackoverflow.com/questions/6838197/get-local-date-string-and-time-string[^]

Posted 9-Jul-13 1:58am

Maciej Los

Updated 9-Jul-13 2:54am

v2

Comments

[no name] 9-Jul-13 8:04am

how to get local time in c# and covert to a format required.

Maciej Los 9-Jul-13 8:13am

You're asking about: I am Trying to Insert the local Time in Server.But failed to insert...
So, my answer is like you see.

http://stackoverflow.com/questions/9888420/asp-net-how-to-get-user-local-time-at-page-load[^]

[no name] 9-Jul-13 8:24am

how to get a format yyyy-mm-dd HH:MM:SS(24Hrs) in javascript

Maciej Los 9-Jul-13 8:26am

http://stackoverflow.com/questions/6838197/get-local-date-string-and-time-string[^]

Amol_B 9-Jul-13 8:35am

That should solve problem for sure

Maciej Los 9-Jul-13 8:53am

Thank you ;)

Manuel john · Answer 2 · 2013-07-09T02:04:00

Solution 5

if you understand the concept just read this query
http://stackoverflow.com/questions/13207956/get-server-time-and-insert-into-mysql-table-via-a-form[^]

Posted 9-Jul-13 2:04am

Manuel john

Comments

wots up frnds 9-Jul-13 8:08am

i think its not help full for him anyway nice work

[no name] 9-Jul-13 8:24am

how to get a format yyyy-mm-dd HH:MM:SS(24Hrs) in javascript

Manuel john 10-Jul-13 3:09am

see this
http://tylerfrankenstein.com/user/4/code/javascript-date-time-yyyy-mm-dd-hh-mm-ss

Thanks7872 · Answer 3 · 2013-07-09T01:56:00

Solution 1

Refer to these links

javascript date and time object[^]

JavaScript getTimezoneOffset() Method[^]

JavaScript Date Format[^]

Regards.. :laugh:

Posted 9-Jul-13 1:56am

Thanks7872

Updated 9-Jul-13 2:26am

v3

Comments

[no name] 9-Jul-13 8:04am

i want to store local time not server time

Thanks7872 9-Jul-13 8:10am

Refer to updated answer.

[no name] 9-Jul-13 8:24am

how to get a format yyyy-mm-dd HH:MM:SS(24Hrs) in javascript

Thanks7872 9-Jul-13 8:26am

Refer to updated answer(3rd link)

Uday P.Singh · Answer 4 · 2013-07-09T01:59:00

Solution 3

Check this:

SQL Server Date Formats[^]

hope it helps :)

Posted 9-Jul-13 1:59am

Uday P.Singh

Comments

[no name] 9-Jul-13 8:05am

i need to store local time using Date object in js and store it into in server

[no name] 9-Jul-13 8:24am

how to get a format yyyy-mm-dd HH:MM:SS(24Hrs) in javascript

Rony Sur · Answer 5 · 2013-07-09T02:03:00

Solution 4

Check the database date column format.

Posted 9-Jul-13 2:03am

Rony Sur

Comments

[no name] 9-Jul-13 8:25am

how to get a format yyyy-mm-dd HH:MM:SS(24Hrs) in javascript