Category: SQL Server

06 Jun 2019 19:07

Joined:	06/06/2011
Level:	Gold
Points:	1173

Points:	1

Oracle query between two dates and timing should be between 8 Pm to 5AM

Please suggest a oracle query between two dates and timing should be between 8 Pm(April1) to 5AM(April2) and group by should come dates

Select datecolumn1,column2 from table where trunc(datecolumn2) between '09-jan-2019' and 12-feb-2019' group by datecolumn1

Timing of the rows should be between 8pm to 5am .. how I should add where condition for this

#769900

08 Jun 2019 12:17

Joined:	06/06/2011
Level:	Gold
Points:	1173

Points:	1

I could group by using dates.. not sure how to select based on timings

#769905

13 Jun 2019 16:56

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	2

hi
you can change like this

Select datecolumn1,column2 from table where trunc(datecolumn2) between '19-jan-12' and 19-feb-12' group by datecolumn1

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

#769909

21 Jun 2019 09:23

Joined:	06/06/2011
Level:	Gold
Points:	1173

Points:	1

@Dotnet developer 2015:
group by datecolumn1 should come for date alone not timing... Timing has to consider at last once grouping by dates done. ( 12 PM,1AM - 7AM).

Above query grouping by datetime..

#769910

21 Jun 2019 11:04

Joined:	06/06/2011
Level:	Gold
Points:	1173

Points:	1

I have 2 where conditions. first and second part should come in different column

where column1 between '01' and '06'
or
column1 between '07' and '12'

Commoncolumn column1 column2
Jan1 01 07
Jan 2 02 08
Jan 3 03 09
Jan4 04 10
Jan5 05 11
jan6 06 12

How this query should come

#769912

22 Jun 2019 11:37

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	2

Hi

Can you share your table script with data then mention your output then only i can trace exactly your issue

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

Oracle query between two dates and timing should be between 8 Pm to 5AM

About dotnetspider.com

Quick Links

General

Services