Question

具体如下: 我的表格有第6栏,其中一栏为Hiredate。年限现在,我只想输出一下星期一或星期二聘用的数据。

目前,我正试图按照以下方针做一些事情:

SELECT name, position, hiredate
FROM table
WHERE hiredate =  monday ;

或

SELECT TO_CHAR(hiredate,  day ) 
FROM table
WHERE TO_CHAR(hiredate,  day ) =  monday ;

这两项工作都没有,我所尝试的其他结构也没有任何变化。

I m fairly certain this is extremely simple, but I am a beginner and am kind of lost on where to go. Any help 或tips would be appreciated.

Answer 1

Hoons的回答是正确的,但只有在贵国的Oracle会议使用英语(NLS_LANGUAGE)的情况下才会奏效。

Another query that work for all languages is

select name, position, hiredate
 from table
where to_char(sysdate,  D ) in (1, 2); -- 1 monday; 2 tuesday

http://www.ohchr.org。

1 monday
2 tuesday
3 wednesday
4 thrusday
5 friday
6 saturday
7 sunday

Answer 2

In general, I have found Oracle s own 10g docs invaluable, you can find them here: Oracle 10g Doc Homepage, and in this case searching for day of week yields some good results, like this one: enter link description here, on that page, I see: DAY Yes Name of day, padded with blanks to display width of the widest name of day in the date language used for this element.

So I m thinking that you re probably getting back Monday, but padded with spaces afterwards. I would probably try to get the abbreviated form, something like:

SELECT TO_CHAR(hiredate,  DY ) FROM table WHERE lower(TO_CHAR(hiredate,  DY )) in ( mon ,  tue );

友情链接