Re: Given quarter, how to get date using to_date?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 10 Oct 1999 13:49:09 +0800
Message-ID: <380028D5.5539@yahoo.com>

Wilson NG wrote:
>
> Oracle sql: Possible to get the date that is the first day of the
> quarter(so what is 'format')?,
> e.g., to_date('4 1999', 'format') return date: 01-OCT-99

Check the 'Q' format mask - it will give what you need..

Cheers
C.

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Oct 10 1999 - 00:49:09 CDT