Posted by Techhead on 02/08/07 17:06

I have a date/time field with a sql format of "datetime" The actual
date/time data format is MM/DD/YYYY^hh:mm:ss:pm or "1/25/2007
12:00:16 AM" Both the date and time are combined on the same field
with a space seperating the two.

I need to run a query on this date/time field using the criteria of
today's date so if I want to search all records with todays date, I
need to query on this field. I don't need the time, but just today's
date (MM/DD/YYYY) portion of the field.

Thanks,
Brian

• Next in forum: Column update structure change
• Prev in forum: odd stored procedure behavior
• Thread view: Need help running query on data/time field

[Reply to this message]