Computer Forums

Search Tech-Forums.net

Member Login

Remember Me? Sign Up! | Forgot Password
 
 
Reply
Old 12-14-2005, 01:34 PM   #1 (permalink)
 
True Techie
Join Date: Aug 2005
Posts: 183
shenlingstyle
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)
office politics's Avatar
 
It's all just 1s and 0s
Join Date: Jan 2004
Location: in the lab
Posts: 4,181
office politics will become famous soon enough
Default

http://www.siteexperts.com/forums/vi...=-1&d_id=15792
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