首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >使用ms sql server选择当前日期项

问使用ms sql server选择当前日期项
EN

Stack Overflow用户
提问于 2012-04-30 17:05:24
回答 1查看 4.3K关注 0票数 1

我正在使用sql语句。请在下面提出我的问题

代码语言:javascript
复制
select 
                               

 master_brand.BRAND_NAME as AcCompanyID, 
                                    lewre_product.SKU_CODE as AcStockID,
                                    lewre_product.SKU_CODE as BarCode,
                                    lewre_product.SKU_CODE as StockBarCode,
                                    lewre_product.SKU_CODE as StockDescription1,
                                    NULL as StockDescription2,
                                    lewre_project.PROJECT_NAME as AcStockBrandID,
                                    lewre_artice.ARTICLE_NUMBER as AcStockGroupID,
                                    icenter_acStockCategory.CATEGORY_CODE as AcStockCategoryID,
                                    icenter_acStockColor.AcStockColorID as AcStockColorID,
                                    lewre_product.SIZE as AcStockSizeID,
                                    'NA' as ISBN,
                                    master_product_type.UOM as AcStockUOMID,
                                    lewre_article_price.FINAL_COST as StockCost,
                                    lewre_article_price.PRICE as StockPrice1,
                                    0 as StockPrice2,
                                    0 as StockPrice3,
                                    0 as StockPrice4,
                                    0 as StockPrice5,
                                    lewre_artice.CREATE_DATE
        
                          

 from [LEWRE.ARTICLE]as lewre_artice,
                                 [iCENTER.ACSTOCKCATEGORY]  as icenter_acStockCategory,
                                 [iCENTER.ACSTOCKCOLOR] as icenter_acStockColor,
                                 [LEWRE.PRODUCT] as lewre_product,
                                 [MASTER.BRAND] as master_brand,
                                 [LEWRE.PROJECT] as lewre_project,
                                 [MASTER.PRODUCT_TYPE] as master_product_type,
                                 [LEWRE.ARTICLE_PRICE] as lewre_article_price
         

                     

   where
                                (icenter_acStockCategory.CATEGORY_ID = lewre_artice.PRODUCT_CATEGORY_ID
                             AND icenter_acStockCategory.PRODUCT_TYPE_ID = lewre_artice.PRODUCT_TYPE_ID)
                             AND lewre_product.ARTICLE_ID = lewre_artice.ARTICLE_ID
                             and lewre_product.COLOR_ID = icenter_acStockColor.COLOR_ID
                             and master_brand.BRAND_ID = lewre_artice.BRAND_ID
                             and lewre_artice.PROJECT_ID = lewre_project.PROJECT_ID
                             and master_product_type.PRODUCT_TYPE_ID = lewre_artice.PRODUCT_TYPE_ID
                             and lewre_artice.ARTICLE_ID = lewre_article_price.ARTICLE_ID
                             and lewre_artice.CREATE_DATE 
                     
                             
                             
                             order by lewre_artice.CREATE_DATE

这是我得到的结果

​

​

我想选择当前示例为date.for create_date (2012-04-30)‘的所有行。怎样才能得到结果呢?请帮帮我

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2012-04-30 17:10:43

将其添加到where子句中。

代码语言:javascript
复制
  lewre_artice.CREATE_DATE >= cast(getdate() as date) and 
  lewre_artice.CREATE_DATE < cast(dateadd(day, 1, getdate()) as date)

getdate()返回当前时间戳,cast(getdate() as date)删除时间部分。dateadd(day, 1, ....)增加了一天。比较将返回CREATE_DATE在该间隔内的行。

票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/10381020

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档