SQL simple date statement

shenlingstyle · 12-14-2005, 01: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.

office politics · 12-14-2005, 03:17 PM

http://www.siteexperts.com/forums/vi...=-1&d_id=15792

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

12-14-2005, 03:17 PM	#2 (permalink)
office politics Dope Tech Join Date: Jan 2004 Posts: 3,589	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode