Sql Date/Time Statement for SQL Server

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sql Date/Time Statement for SQL Server

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Sql Date/Time Statement for SQL Server

Page: [1]


dzirkelb1 Posts: 1283 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	Sql Date/Time Statement for SQL Server - 5/2/2008 11:40:49 I have a data column that is formated as a datetime column on an sql 2000 server. However, it includes the time in the field also...here is an example of a piece of data: 05/01/2008 7:12:50 PM When i try to query it by 5/1/2008 only, I get no results. How can I query this data for just the date?


Spooky Posts: 26560 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Sql Date/Time Statement for SQL Server - 5/2/2008 15:53:20 Use BETWEEN '05/01/2008' AND '05/02/2008' _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to dzirkelb1)


dzirkelb1 Posts: 1283 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: Sql Date/Time Statement for SQL Server - 5/2/2008 16:01:01 That works, thanks! (in reply to Spooky)

Page: [1]

All Forums >> Web Development >> ASP and Database >> Sql Date/Time Statement for SQL Server

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts