Retrieving date given week no.

From: Larry Barea <larry_at_tarik.demon.co.uk>
Date: Sun, 12 Jun 1994 01:18:17 +0000
Message-ID: <1994Jun12.011817.996_at_tarik.demon.co.uk>

Does anyone know how I could retrieve the last sunday of a given week given the week number ?

I know you can do a to_char(sysdate, 'WW') but I'm after the opposite.

Any ideas would be greatly appreciated.

Thanks

-- 

Larry Barea  (larry_at_tarik.demon.co.uk)

Received on Sun Jun 12 1994 - 03:18:17 CEST

This message: [ Message body ]
Next message: Sandor Nieuwenhuijs: "Re: How can I count rows fast ?"
Previous message: David Hiltz: "Re: C in stored procedures"
Next in thread: Michael Sallwasser: "Re: Retrieving date given week no."
Reply: Michael Sallwasser: "Re: Retrieving date given week no."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message