Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dates and Time

Status
Not open for further replies.

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
 
Assuming you field is a datetime

Substr(to_char(pol_upd_date, 'MM/DD HH:MI'), 7,5) = '02:30'

Ian
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top