Computer Forums - View Single Post

shenlingstyle · 12-14-2005, 02:34 PM

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.

12-14-2005, 02:34 PM	#1 (permalink)
shenlingstyle True Techie Join Date: Aug 2005 Posts: 183	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