CREATE FUNCTION EXTRACT_DATE(ADATE DATE) RETURNS DATE
AS
BEGIN
  RETURN EXTRACT(YEAR FROM ADATE) || '-' || EXTRACT(MONTH FROM ADATE) || '-' || EXTRACT(DAY FROM ADATE);
END 

CREATE PROCEDURE CHECK_UASERDATE(ADATE TIMESTAMP)
AS
  DECLARE SEC INT;
  DECLARE MIN INT;
  DECLARE H INT;
  DECLARE CUR_DATE TIMESTAMP;
  DECLARE BEGIN_DATE TIMESTAMP;
BEGIN
   CUR_DATE = CAST(EXTRACT(YEAR FROM CURRENT_TIMESTAMP) || '-' || 
                             EXTRACT(MONTH FROM CURRENT_TIMESTAMP) || '-' || 
                             EXTRACT(DAY FROM CURRENT_TIMESTAMP) AS TIMESTAMP);  
   BEGIN_DATE = CAST(EXTRACT(YEAR FROM ADATE) || '-' || 
                             EXTRACT(MONTH FROM ADATE) || '-' || 
                             EXTRACT(DAY FROM ADATE) AS TIMESTAMP);  
   IF (ADATE > BEGIN_DATE AND CUR_DATE - BEGIN_DATE > 1) THEN
     EXCEPTION E_INCORRECT_DATE;
END

select lc.*, tc.name as f_name from ZM_LOAD_CASH lc
left join th_classif tc
on lc.filialindex_load = tc.id_th_classif 
where USER_LOAD <> 'Дисконт' 
  and TIME_WRITE > '$TIME_WRITE1' and TIME_WRITE <= '$TIME_WRITE1 23:59:59.0000'   
  and FULL_LOAD in ('$TIME_WRITE2') $SORT