simple sql command

[rswamin]

hi friends

can anyone tell me the reason for this.

when i execute the query

select ename from emp where to_char(hiredate, 'dd-mm')=
'17-11' ;

iam getting the result. but when i execute the following query,

select ename from emp where to_char(hiredate, 'dd-mon')=
'17-NOV' ;

no rows are selected.

can any one expalin the reason for this.

thanks in advance.

regards
swaminathan

[balajiyes]

the format string in TO_CHAR is case-sensitive. hence the foll. query will give the required output (using dd-MON format string).

select ename from emp where to_char(hiredate, 'dd-MON')=
'17-NOV' ;

[rswamin]

thank you balajiyes for your reply

regards
swaminathan