Order by Current time

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi All,
I am facing a problem order by time in sql

My problem is the ordering should start from Current time.
All value will populate but the 1st value will be Current time.

Below is my query
-----------------------------------

select b.E_Episode_AirTime, a.*,b.*,c.*,c.e_episodeAirDate as AirDate,c.e_episodeAirTime 
	as AirTime,substring(a.E_Episode_Overview,0,100) as e_overv     /*substring to describe the character or binary text  */
	from EpisodeMaster a inner join
	EpisodeDetails b on a.E_Episode_Id=b.E_Episode_Id  	 
	
	inner join EpisodeMoreDetails c on
	a.E_Episode_Id = c.E_Episode_Id
	
	and convert(varchar, b.E_Episode_AirDate, 111)= convert(varchar, getdate(), 111) 	
	and a.IsActive = 1

Please help
Thanks in advance

Posted 15-Sep-11 5:46am

Raj tilak Bose

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas Bhardwaj · Answer 1 · 2011-09-15T05:57:00

Solution 1

What's the problem? Use Order by[^] clause.

Posted 15-Sep-11 5:57am

Manas Bhardwaj

Comments

Dalek Dave 15-Sep-11 15:41pm

Good Answer.

Manas Bhardwaj 16-Sep-11 6:06am

Thanks!

Kschuler · Answer 2 · 2011-09-15T07:50:00

Your question is not very clear. Try Improving the Question and telling us in real words what you are doing.

As a guess, it looks like you are trying to show information for television shows. If you only want to see shows that are airing at the current time, then you probably want to use the WHERE clause and filter your data to only pull the records for shows that are running right now. If you are really asking for sorting help...then for what? You can sort by your Air_date field using the Order By that Manas Bhardwaj suggested in Solution 1. But if your data contains records for episodes in the future, those will display as well. It all depends on details that you haven't provided in your question.