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
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

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?

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: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for calendar or row generator.

Previous Topic: SQL Plus script question
Next Topic: SQL: Listing/Showing functions created by "CREATE function"?
Goto Forum:

Current Time: Sun Aug 20 03:09:13 CDT 2017

Total time taken to generate the page: 0.12859 seconds