I wrote a real simple trunc() function fashioned after oracles but
used some simple rules to let me have modulo date_trunc. I don't have
the code anymore. I might sit down and refigure it out...
On Fri, Jun 20, 2008 at 8:54 PM, Decibel! <[EMAIL PROTECTED]> wrote:
> Try using extract instead of t
Try using extract instead of to_char. date_trunc might also be of use.
On Jun 20, 2008, at 8:05 AM, Chris Preston wrote:
Hello All,
I have used the cross tab function to setup tables that display
months' data, however i need to display years data instead of the
months.. so i would display 2