Dates and Time

[Sahubba]

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

 

[IanWaterman]

Assuming you field is a datetime

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

Ian

 

[ChrisHunt]

Why bother with the SUBSTR, Ian?

to_char(pol_upd_date, 'HH24:MI:SS') = '02:30:00'

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

 

[Sahubba]

Thanks For your input!

 

[IanWaterman]

Good point Chris, over thinking the solution ;-)

Ian

 

[Beilstwh]

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