plsql判断日期是否属于月末

最新推荐文章于 2024-05-31 10:14:49 发布

原创最新推荐文章于 2024-05-31 10:14:49 发布 · 6.1k 阅读

CC 4.0 BY-SA版权

</pre><pre name="code" class="sql"><img src="https://img-blog.youkuaiyun.com/20140820143428640?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdzExNzQzMzU2ODU=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="" />

declare
now number;
lastday number;
begin
  select substr(to_char(last_day(sysdate)),1,2) into lastday from dual;
  select substr(to_char(sysdate),1,2) into now from dual ;
  if( now = lastday) then
  dbms_output.put_line('yes');
  end if;
  
  if( now <> lastday) then
  dbms_output.put_line('no');
  end if;
  
  end;
  上面是我自己写的
下面这个是老师写的，经典
<pre name="code" class="sql">begin
  if trunc(sysdate) = last_day(trunc(sysdate)) then
     dbms_output.put_line('yes');
  else
     dbms_output.put_line('no');
  end if;
end;
/

#！/bin/bash
A=`date +%d`#当前日期
B=$(cal|xargs|awk  '{print $NF}')#获取该月最后一天
if[ "$A = "$B" ]; then
   echo "yes"
else
   echo "no"
fi

#！/bin/bash
#set -x

#A=$(date -d tomorrow '+%d') #获得明天的时间
A=`date -d '1 day' +%d` #获得明天的时间
if [ "$A" = "01" ]; then
echo "yes"
else
echo "no"
fi