SQL Dates - Financial Year

[Dolph]

Thread necromancy for this:
"You probably don't need all the TO_CHAR, TO_DATE crap if you're working with native oracle date formats."
Always always *always* mask your dates (in Oracle) when writing code (as opposed to just running a query to check something).

Well worth a thread necro, never rely on native date settings, it makes any form of migration an absolute clucking nightmare.

 

[gpuerrilla]

Just create csv witj primary key as start date to end date for every day. And then have flaf in the calender table specifying whether a date is in your business year. Then do an inner join in your query to the sql table and calender table.

Kind of following ya on this but few typos is flaf deliberate?