Re: [SQL] Cross Tab Functions

2008-06-20 Thread Scott Marlowe
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

Re: [SQL] Cross Tab Functions

2008-06-20 Thread Decibel!
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