Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dateandtime search Expand / Collapse
Author
Message
Posted Monday, June 23, 2008 2:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 23, 2014 10:08 AM
Points: 13, Visits: 32
<-- new at sql

I'm trying to run a query on time but my date and time are in the same field.

Example I'm trying to get the rows between 6/22/2008 12:00:54 AM to 6/23/2008 12:11:57 AM

Unfortunantly I don't have the luxury of splitting up the date and time.

Select * from log where dateandtime ?????????
Post #522188
Posted Monday, June 23, 2008 3:19 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 8:03 PM
Points: 6,266, Visits: 2,027
amdavis (6/23/2008)
<-- new at sql

I'm trying to run a query on time but my date and time are in the same field.

Example I'm trying to get the rows between 6/22/2008 12:00:54 AM to 6/23/2008 12:11:57 AM

Unfortunantly I don't have the luxury of splitting up the date and time.

Select * from log where dateandtime ?????????


what is the problem with:

Select * from log where dateandtimecolumn between '6/22/2008 12:00:54 AM' and '6/23/2008 12:11:57 AM'





* Noel
Post #522206
Posted Tuesday, June 24, 2008 7:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 23, 2014 10:08 AM
Points: 13, Visits: 32
Thanks! I need to learn more keywords :D
http://www.1keydata.com/sql/sql-syntax.html
Post #522514
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse