Fun with dates 1

[LaurenM]

Is there any way that I can do comparisons with just a year? What I am working on is a user enters a four digit year, i.e. 2006, now is there anyway I can do any date manipulation from that, specifically put 31/12/ in front of that? B/c if I can then all other date functions are possible. I have tried concating 31/12/ to the year inputted but that didn't work, unless I did it wrong. I welcome any thoughts and requests for clarification.

Lauren

Lauren McDonald, B.Sc.
Programmer Analyst
Saskatchewan Healthcare Employees' Pension Plan

 

[LKBrwnDBA]

Try using the TO_DATE() function:

TO_DATE(:YEAR||'1231','YYYYMMDD')

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LaurenM]

Thanks!! It works great!

Lauren McDonald, B.Sc.
Programmer Analyst
Saskatchewan Healthcare Employees' Pension Plan