Computer Forums

Member Login

Remember Me? Sign Up! | Forgot Password
 
Slogan
 
Closed Thread
Old 12-14-2005, 02: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  
Old 12-14-2005, 04: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,410

office politics will become famous soon enough

Default

http://www.siteexperts.com/forums/vi...=-1&d_id=15792
office politics is offline  
 
Closed Thread

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