寻找一个月的第一个星期六 [英] Finding first saturday of month
本文介绍了寻找一个月的第一个星期六的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
选择截断(sysdate,''MM'')
来自双$
查询是查找当月的第一个星期六?
Select trunc(sysdate,''MM'')
from dual
of course gives me the first day of the month, may I ask what the
query is to find the first saturday of the month?
推荐答案
" Solomon Grundy" <螺******** @ netscape.net>在消息中写道
news:6a ************************** @ posting.google.c om ...
|选择trunc(sysdate,''MM'')
|来自双
|当然给了我这个月的第一天,请问
|查询是找到本月的第一个星期六?
查看NEXT_DAY函数
; - {mcs
"Solomon Grundy" <lo********@netscape.net> wrote in message
news:6a**************************@posting.google.c om...
| Select trunc(sysdate,''MM'')
| from dual
| of course gives me the first day of the month, may I ask what the
| query is to find the first saturday of the month?
check out the NEXT_DAY function
;-{ mcs
Mark C. Stock写道:
Mark C. Stock wrote:
" Solomon Grundy" <螺******** @ netscape.net>在消息中写道
新闻:6a ************************** @ posting.google.c om ...
|选择trunc(sysdate,''MM'')
|来自双重
|当然给了我这个月的第一天,请问是什么
|查询是找到本月的第一个星期六?
查看NEXT_DAY函数
; - {mcs
"Solomon Grundy" <lo********@netscape.net> wrote in message
news:6a**************************@posting.google.c om...
| Select trunc(sysdate,''MM'')
| from dual
| of course gives me the first day of the month, may I ask what the
| query is to find the first saturday of the month?
check out the NEXT_DAY function
;-{ mcs
小心使用trunc(sysdate):
SQL>从双重中选择trunc(sysdate,''MM'');
TRUNC(SYSDATE,''
---------- -----
01-FEB-04
-
问候,
Frank van Bortel
And be careful with trunc(sysdate):
SQL> select trunc(sysdate,''MM'') from dual;
TRUNC(SYSDATE,''
---------------
01-FEB-04
--
Regards,
Frank van Bortel
" Frank van Bortel"< fv ******* *@netscape.net>在留言中写道
news:c1 ********** @ news4.tilbu1.nb.home.nl ...
| Mark C. Stock写道:
|>" Solomon Grundy" lo ******** @ netscape.net>写在留言中
|>新闻:6a ************************** @ posting.google.c om ...
|> |选择trunc(sysdate,''MM'')
|> |来自双重
|> |当然给了我第一天的这个月,我可以问一下
|> |查询是查找当月的第一个星期六吗?
|>
|>查看NEXT_DAY功能
|>
|> ;; - {mcs
|>
|>
|
|小心使用trunc(sysdate):
| SQL>从双重中选择trunc(sysdate,''MM'');
|
| TRUNC(SYSDATE,'
| ---------------
| 01-FEB-04
|
| -
|
|问候,
| Frank van Bortel
|
frank,
OP打算使用trunc(sysdate,''MM''),这是可靠的返回当前月份的第一天
- 你建议用什么方式使用trunc(sysdate)来小心?
; - {mcs
"Frank van Bortel" <fv********@netscape.net> wrote in message
news:c1**********@news4.tilbu1.nb.home.nl...
| Mark C. Stock wrote:
| > "Solomon Grundy" <lo********@netscape.net> wrote in message
| > news:6a**************************@posting.google.c om...
| > | Select trunc(sysdate,''MM'')
| > | from dual
| > | of course gives me the first day of the month, may I ask what the
| > | query is to find the first saturday of the month?
| >
| > check out the NEXT_DAY function
| >
| > ;-{ mcs
| >
| >
|
| And be careful with trunc(sysdate):
| SQL> select trunc(sysdate,''MM'') from dual;
|
| TRUNC(SYSDATE,''
| ---------------
| 01-FEB-04
|
| --
|
| Regards,
| Frank van Bortel
|
frank,
the OP was intending to use trunc(sysdate,''MM''), which reliably returns the
first day of the current month -- in what way are you suggesting to be
careful with trunc(sysdate)?
;-{ mcs
这篇关于寻找一个月的第一个星期六的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文