If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

filter between 'sysdate 22:00:00' and 'sysdate+1day 06:30:00'

Started by jiahauh, 20 Oct 2015 09:35:21 PM

Previous topic - Next topic

jiahauh

hi
  I want to filter between 'sysdate 22:00:00' and 'sysdate+1day 06:30:00', but when i used timestamp and set time as 22:00:00. it shows hour should be 1~12. and when i use ' 10:00:00 PM' it returns error sql -28 and ORA-01855.

i used the filter as
  between cast(concat( _last_of_month (_add_months (sysdate(),-8)),' 10:00:00 P.M.'),timestamp) and cast(concat (_first_of_month (_add_months (sysdate(),-4)),'06:30:00.000'),timestamp)

  Any help to achieve this is appreciated