如何获得每日的上次完成工作日期 [英] How to get daily last completed job date

问题描述

你好

我有一个存储过程，其中
当前Todate是公司xx的当前日期.现在将其更改为每个表的最后完成日期(一天结束).

我必须将今天"列设置为这一天的结束日期

plz 的操作方法请帮助

Hello

I have a stored procedure in which
Currently Todate comes as current date from companyxx. Now this is to be changed to last completed (end of day) date for each table.

I have to set today column to this end of the day date

How to do it plz please help

推荐答案

Here is example for you.
1) create table with date column
create table dinesh_insertDate
(name varchar(30),
address varchar(30),
      date datetime)  


 2)see current date by function
  select getdate()

3)insert values with datetime
 INSERT INTO dinesh_insertDate
(name, address, date)
VALUES
('dinesh',' virar', getdate())

4)see values inserted.
select * from dinesh_insertDate
5)select conditional date filter 
to see today data.

这篇关于如何获得每日的上次完成工作日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！