Mar 6, 2013 #1 Sahubba Programmer Mar 16, 2011 108 US I need to create a query that has a date range with a certain time. Example, 03/01 2:30 03/02 2:30 03/03 2:30 03/04 2:30 The results the date range will display different dates but with a set time. Please let me know if this makes sense
I need to create a query that has a date range with a certain time. Example, 03/01 2:30 03/02 2:30 03/03 2:30 03/04 2:30 The results the date range will display different dates but with a set time. Please let me know if this makes sense
Mar 7, 2013 #2 IanWaterman Programmer Jun 26, 2002 3,511 GB Assuming you field is a datetime Substr(to_char(pol_upd_date, 'MM/DD HH:MI'), 7,5) = '02:30' Ian Upvote 0 Downvote
Mar 7, 2013 #3 ChrisHunt Programmer Jul 12, 2002 4,056 GB Why bother with the SUBSTR, Ian? Code: to_char(pol_upd_date, 'HH24:MI:SS') = '02:30:00' -- Chris Hunt Webmaster & Tragedian Extra Connections Ltd Upvote 0 Downvote
Why bother with the SUBSTR, Ian? Code: to_char(pol_upd_date, 'HH24:MI:SS') = '02:30:00' -- Chris Hunt Webmaster & Tragedian Extra Connections Ltd
Mar 7, 2013 Thread starter #4 Sahubba Programmer Mar 16, 2011 108 US Thanks For your input! Upvote 0 Downvote
Mar 7, 2013 #5 IanWaterman Programmer Jun 26, 2002 3,511 GB Good point Chris, over thinking the solution ;-) Ian Upvote 0 Downvote
Mar 12, 2013 #6 Beilstwh Programmer Jul 13, 2005 819 US As long as Sahubba is looking for 2:30am, if in after noon then look for 14:40 Bill Lead Application Developer New York State, USA Upvote 0 Downvote
As long as Sahubba is looking for 2:30am, if in after noon then look for 14:40 Bill Lead Application Developer New York State, USA