#DateForumTypeThreadPost
111 Sep 2014 @ 12:35 PDTDatabaseReplyConverions of timestamp to FORMAT 'MM/DD/YYYYBHH:MI:SS'Hi Dieter, Can you help me withe the below logic END_EFF_DATE=(BEG_EFF_DT of next record)-  1 micro second. For me the MAX (END_EFF_DT) is 31/12/9999.....thats y using the below format. --...