从特定日期/时间我想计算我自己的日期/时间 [英] From a particular date/time i want to calculate my own date/time

问题描述

假设我有一个名为current_date的日期时间字段。我手动将其第一个单元格的值存储为''5/17/2013 10:00:00 AM''，这是当前系统日期/时间。我希望第二个单元格在24小时后自动填满，其值应为''5/18/2013 10:00:00 AM''。等等它每天都在继续。

如何在没有互联网且没有系统日期/时间帮助的系统中进行操作？可能吗？如果是，那么如何。如果你用代码解释我会更感激。您可以使用SQL或ASP.NET/C#来执行此操作。



谢谢

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

推荐答案

您可以使用SQL Server代理作业。它是一个执行SQL作业并处理其他自动化任务的过程。它可以配置为在系统引导时自动运行，也可以手动启动。它是Microsoft SQL Server的一个组件。



请参阅以下链接以使用SQL Server作业



SQL Server代理工作



< a href =http://msdn.microsoft.com/en-us/library/ms181153(v=sql.105).aspx> MSDN：如何创建SQL Server代理作业

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

这篇关于从特定日期/时间我想计算我自己的日期/时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！