|
|
|
|
Re: Any function of oracle to return the quarter of sysdate [message #432454 is a reply to message #432448] |
Tue, 24 November 2009 05:52   |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Michael, that seems a little harsh.
Ved has clearly tried to provide hints rather than the solution.
The overall post from ved, if put together as intended, will actually return the result required by the op. It would be a massively over convoluted tactic, but it would do the job.
|
|
|
|
Re: Any function of oracle to return the quarter of sysdate [message #432460 is a reply to message #432458] |
Tue, 24 November 2009 06:00   |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Its_me_ved wrote on Tue, 24 November 2009 11:56Sir, I first wanted to put the solution. But ...
Its you who once told me not to provide solution but hint.And I just did that.
And good on you for doing that, the problem is that it's not the best solution. Have a look at the documentation link that Michel posted. The most appropriate solution can be gleaned from there
[Updated on: Tue, 24 November 2009 06:01] Report message to a moderator
|
|
|
|
Re: Any function of oracle to return the quarter of sysdate [message #432463 is a reply to message #432460] |
Tue, 24 November 2009 06:07   |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
the problem is that it's not the best solution
Sir,
And..I never said it was a best one. I just tried. My problem is that I can not remember each and every word of the documentation.
When the OP asked for it , I just felt that I should try something and thats what I did.
TO_CHAR(SYSDATE,'Q') FROM DUAL
@Michel Sir, Thanks ...
|
|
|
|
|