All Forums Database
05 Nov 2014
coalesec((min(start_dt) over(partition by a_id, b_id order by start_dt asc rows between 1 following and 1 following ))-1,'9999-0

Hi ,
 
Getting error when i run below stmt ... Plzz help on this , if it wont work i need to write update separately to update null recs i want to avoid it...
 
coalesec((min(start_dt) over(partition by a_id, b_id order by start_dt asc rows between 1 following and 1 following ))-1,'9999-09-09') as end_dt
 
error msg :: expected something between '(' and '('. [SQL State=42000, DB Errorcode=3706]
 
Thanks,
Rajendra Reddy
 
 

dnoeth 4628 posts Joined 11/04
06 Nov 2014

Hi Rajendra,
it's coalesce instead of coalesec :-)

Dieter

You must sign in to leave a comment.