which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM

Answer Posted / muhammadrashidmughal

select * from urTable
Where urDateColumn
Between '2007-10-20 17:00:00 PM'
and '2007-10-21 09:00:00 AM'

Is This Answer Correct ?    14 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to call a function from a stored procedure in SQL Server ?

553


What is an indice?

577


What are the different kinds of ssrs reports?

170


What is bcnf normalization form?

669


What is role playing dimension with two examples? : sql server analysis services, ssas

597






What is Extended user-defined?

537


What are sql servers used for?

513


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

575


Explain can SSRS reports Cache results?

112


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

607


How to access the deleted record of an event?

579


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1059


What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

536


Do you know concepts and capabilities of sql server?

584


What are key, name and value columns of an attribute? : sql server analysis services, ssas

575