OCP-1Z0-051 第53题日期格式_promo begin date-CSDN博客

本文通过一个具体案例，展示了如何使用SQL语句从PROMOTIONS表中筛选特定条件的数据，包括如何正确设置日期和类别筛选条件。

一、原题

View the Exhibit and examine the data in the PROMOTIONS table.
PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000.
Which SQL statement would you use?

A. SELECT promo_name, promo_cost, promo_begin_date
    FROM promotions
    WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
B. SELECT promo_name, promo_cost, promo_begin_date
    FROM promotions
    HERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';
C. SELECT promo_name, promo_cost, promo_begin_date
    FROM promotions
    WHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';
D. SELECT promo_name, promo_cost, promo_begin_date
    FROM promotions
    WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';

答案：D

二、题目翻译

检查PROMOTIONS表的数据
PROMO_BEGIN_DATE列使用默认日期格式dd-mon-rr存储.
要生成一个报表，显示所有2000年1月1日之前的、促销种类为POST的promos的名称，成本和开始日期，
应该使用哪个SQL语句？

三、题目解析

A和B选项都不正确，promo_begin_date条件格式不对。
C选项不正确，promo_category 条件不对。