getting month from a date type column
Posted on 2007-11-16
Hello all. I have a query where the user can specify the month and year of the data. These will be two separate parameters. I have tried all kinds of ways to do this. This is one of many attempts that are not working. (see below) Why does the first query not return anything when I have data in there but the second query returns data.
WHERE to_char(transactions.datetime,'Month') = 'November';
Column has data like:
So I am not understanding the difference here.
Also this will go into oracle reports and I will have to display the user para month as NOVEMBER.
Nothing is working. I can get the query to work right two different ways but when I add it to the report it ill not work. Please help.