条款混淆之间的SQL [英] Sql Between Clause Confusion

问题描述

让我说我有1个表包含商品代码，batchano，开仓股票，收货股票，发行股票，收盘股票，添加日期

收据开盘+套件=收盘

问题是关闭问题

我已经交易形式grn（好收货票据收据在其添加的日期有grndate）和MIN（物料发行说明问题和注意事项）



现在我想要记录日期

今天就说12/12/2012



所以我的条件中的条款



我的到期日将是12/12/2012

和FROM日期记录的日期插入所以我怎么能得到这个日期

Lets say i have 1 table Contain record of itemcode,batchano,opening stock ,receipt stock, issue stock ,Closing Stock,adddate
receipt is opening + recept =closing
issue is closing-issue
and i have made transaction form grn(Good Receive Note Receipt having grndate on which date it is added) and MIN(Material Issue Note Issue and mindate)

Now i want record as on date
let say on today 12/12/2012

so in my condition where clause

my To Date will be 12/12/2012
and FROM Date on which date record has inserted so how could i get this date

推荐答案

简单

< = 12/12/2012

<截止日期

simple
< = 12/12/2012
< as on date

这篇关于条款混淆之间的SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！