Date function

building reports webintelligence
1

Why the following statement is showing error in TOAD ?

trunc(DW_SPS.SPS_AI_REIMB_CASE.CREATE_DT) BETWEEN to_date(trunc(‘01-01-2008 00:00:00’),‘mm/dd/yyyy’) AND to_date(trunc(‘30-11-2009 00:00:00’),‘mm/dd/yyyy’)

Developer_Designer (BOB member since 2009-08-09)

2

Your DATE conversions seems incorrect, try something along the lines of:

TO_DATE ('24-12-2009', 'dd-mm-yyyy')

No TRUNC necessary by the way IMHO, and if then use:

TRUNC ( TO_DATE ('24-12-2009', 'dd-mm-yyyy') )

Another example (from www.psoug.org):

SELECT 
   TO_DATE('January 12, 2005, 11:03 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = American')
FROM 
   DUAL;

Andreas :de: (BOB member since 2002-06-20)