How to populate an LOV with SYSDATE, SYSDATE-1,etc.

From: Mark Hide <mch_at_markhide.demon.co.uk>
Date: 1997/07/07
Message-ID: <6bioBCAzGKwzEwT3_at_markhide.demon.co.uk>#1/1

[Quoted] [Quoted] Could anyone tell me what SQL I need to generate a record group that [Quoted] will consist of the ten dates leading up to today ?

Can I do it with a simple query or do I have to use PL/SQL ?

Thanks.

-- 
Mark Hide

Received on Mon Jul 07 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Steve Johnson: "Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc."
Previous message: Gerhard Moeller: "A: Designer/2000 Vers. 1.3 for NT does not compile"
Next in thread: Steve Johnson: "Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc."
Reply: Steve Johnson: "Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc."
Reply: Gary Assa: "Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc."
Reply: Jurij Modic: "Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc."
Reply: Peter H. Larsen: "Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc."

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

Original text of this message