From a particular date/time i want to calculate my own date/time

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

suppose i have a datetime field named as current_date. I manually stored the value of its 1st cell as '5/17/2013 10:00:00 AM' which is current system date/time. I want the second cell to be filled up automatically exactly after 24 hours and its value should be '5/18/2013 10:00:00 AM'. And so on it continues to do everyday.
How to do it in a system where internet is not available and without taking the help of system date/time? Is it possible? If yes then how. If you explain with codes i will appreciate it more. You can either use SQL or ASP.NET/C# to do it.

Thanks

Posted 16-May-13 19:25pm

gyaan86

Updated 16-May-13 19:29pm

v2

Add a Solution

1 solution

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)

Thanks7872 · Accepted Answer · 2013-05-16T19:37:00

Solution 1

You can make use of SQL Server Agent Jobs. It is a process which executes SQL jobs and handles other automated tasks. It can be configured to run automatically when the system boots or it can be started manually. It is a component of Microsoft SQL Server.

Refer to below link for working with SQL Server Jobs

SQL Server Agent Jobs

MSDN:How to create a SQL Server Agent Job

Posted 16-May-13 19:37pm

Thanks7872

Comments

gyaan86 17-May-13 6:25am

Thank you Rohan Leuva for your reply. I tried SQL Server Agent Job and it worked fine. But Even SQAJ depends upon the system date/time. If i change the system date/time it will stop working (I have checked it too). I want it to be auto-filled without any help of system date and Internet if it is possible by any means. Otherwise i will have to make Internet mandatory for my client.
Thanks

Thanks7872 17-May-13 6:55am

Accept that you can check online date and time.But if you neglect internet also then you have to rely solely on system date time.It can be considered as a limitation.