I have a table called Transactions that has a column called trans_date. I am just trying to do a simple query in the SQL*Plus command window The query is When I run this query I get not valid month and there is a little * under trans_date. Most of what I have read suggests the query is right but I
Tag: to-date
What is the best method to change Year from YYYY to FYYY format in SQL?
I have year in YYYY format and I want to convert it to FYYY format. So, for instance, 2014 will be FY14, 2009 will be FY09, so on and so forth. I’m creating a View that contains a SUM aggregate …
How do I convert Months from Numeral to String Form in SQL Query Containing GROUP BY?
So, I’m creating a View that pulls a bunch of data (with a SUM aggregate on one field). The query contains GROUP BY clause and when I do the month conversion in the query as follows, I get an %invalid …