ORACLE自增函数，一般函数

create or replace function oracle_to_unix(in_date in date) return number is
begin
  return((in_date - to_date(‘19700101‘, ‘yyyymmdd‘)) * 86400 -
         to_number(substr(tz_offset(sessiontimezone), 1, 3)) * 3600);
end oracle_to_unix;

create or replace function unix_to_oracle(in_number number) return date is
begin
  return (to_date(‘19700101‘,‘yyyymmdd‘) + in_number/86400
  + to_number(substr(tz_offset(sessiontimezone),1,3))/24);
end unix_to_oracle;

SELECT *
  FROM (SELECT mobile,
               /*UNIX_TIMESTAMP(create_date) as create_date,*/
               /*to_timestamp(create_date, ‘yyyy-mm-dd hh24:mi:ss‘) as create_date,*/
               /*to_timestamp(create_date) as create_date,*/
               oracle_to_unix(create_date)  as create_date,
               code,
               code_status,
               uuid
        /*top (1)*/
          FROM R_CHECK_CODE
         WHERE code_status = ‘0‘
           and mobile = ‘138******‘
        /*and rownum<=1*/
         order by create_date desc) s
 where rownum <= 1