Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mtop
Starting Member
8 Posts |
 Posted - 2011-05-10 : 13:54:18
|
| I would be grateful if anyone can point me in the right direction or even provide a solution .......I have been asked by the reporting team to extract data from a view for the month of MarchHowever, when I look at the description for the view the "Created Date" field is defined as NOT NULL NUMBER(15) There is a function SECONDS-TO-DATE that I use to TO_CHAR the data to a Date.What I was looking at doing was declaring two variables , V-start and v-end and then running a select * from view where "Created Date" BETWEEN v-start AND v-end The nearest I've got is an ADD_MONTHS from SYSDATE and then I manually adjust the output to fit ....... which isn't even closeMtop |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-10 : 13:57:01
|
| Sounds like you're using Oracle, SQLTeam is a Microsoft SQL Server site. There's an Oracle forum over at http://dbforums.com/ you might try. |
 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2011-05-10 : 14:20:06
|
Ditto Rob...but in general terms, if your 'CreatedDate' is in terms of seconds from some point in time...then it seems it would be easier to define v-Start and v-End in terms of seconds also. That would give you 3 numbers to compare...aka. 43598 between 34424 and 55353Good luck thoughCorey I Has Returned!! |
|
|
|
|
|
|
Date held as a Number