On Sat, Dec 6, 2008 at 3:40 PM, Frank Schönheit - Sun Microsystems Germany
>
> Of course such functions could also be used to create a string which has
> the date formatted as you want:
>  SELECT YEAR( <sales_date> ) || '/' || MONTH( <sales_date> )
>  FROM <sales>


That works great! Exactly what I needed.

Thanks Frank!

-- 
Christopher Stamper

Email: [EMAIL PROTECTED]
Web: http://tinyurl.com/2ooncg
gTalk: http://tinyurl.com/6e359r
Skype: cdstamper

Reply via email to