Computer ForumsComputers  

Go Back   Computer Forums > Programmers Lounge > Programming Discussions

Reply
 
LinkBack Thread Tools Display Modes
Old 12-14-2005, 01:34 PM   #1 (permalink)
True Techie
 
Join Date: Aug 2005
Posts: 184
Default SQL simple date statement

Hi, just had an urgent question for writing a specific SQL statement.

I have a table called BAGGAGE_ALLOCATION, there is a field in it called START_TIME, that is in a date format. The data in this field look like this:

11/23/2003 1:11:00 AM

How can I write a SQL statement to extract all records that occur on December 15th, 2005?

Thanks for any help. Greatly appreciated.
__________________
ASUS A7N8X-E Deluxe
AMD Athlon XP 3200+
Zalman CNPS7000B-Cu
OCZ 1GB Platinum PC3200 Rev2 Dual Channel
ATI Radeon 9800 Pro
Enermax Noisetaker 485W
2 x 80GB SATA Maxtor Diamondmax 10 on RAID 0
shenlingstyle is offline   Reply With Quote
Old 12-14-2005, 03:17 PM   #2 (permalink)
Dope Tech
 
Join Date: Jan 2004
Posts: 3,589
Send a message via ICQ to office politics Send a message via AIM to office politics Send a message via Yahoo to office politics
Default

http://www.siteexperts.com/forums/vi...=-1&d_id=15792
__________________
Tech IMO.com | ExtremeTech.com | ASP Free.com | SysOpt.com | Tech Support Guy.org
DB Forums.com | Cyber Tech Help.com | Lazy Forums.com | Warrior Nation.net

'If you don't stand for somethin you'll fall for anything' - Dr. Dre Been there, done that
office politics is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 12:55 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0