Home » SQL & PL/SQL » SQL & PL/SQL » Query to produce list of minutes in a day (Oracle 10g, TOAD, Crystal reports)
icon5.gif  Query to produce list of minutes in a day [message #316309] Thu, 24 April 2008 10:29 Go to next message
dd15_15
Messages: 1
Registered: April 2008
Junior Member
Hi, I'm new to the forums.

I need some help on with a query I've been working on.
Basically, I'm producing a graph in Crystal Reports and need the x-axis to show every minute for a specific day (let's say sysdate-1). eg.
2008-04-28 00:00:00
2008-04-28 00:01:00
2008-04-28 00:02:00
2008-04-28 00:03:00
2008-04-28 00:04:00
etc...

Unfortunately the only way I can think to do this is either by using 1441 select or insert statements for each minute, which won't work as the query is too long for Crystal Reports to process; or by using some form of looping, but I cannot get this to work

Does anyone have any ideas to help?

Thanks
Re: Query to produce list of minutes in a day [message #316310 is a reply to message #316309] Thu, 24 April 2008 10:35 Go to previous message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for calendar or row generator.

Regards
Michel
Previous Topic: budgetdata
Next Topic: Calling pipelined function from pipelined function.
Goto Forum:
  


Current Time: Thu Dec 08 05:54:51 CST 2016

Total time taken to generate the page: 0.08494 seconds