</pre><pre name="code" class="sql"><img src="https://img-blog.csdn.net/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