ÇóÒ»¸öOracleº¯Êý - Oracle / ¿ª·¢

ʵÏÖ¹¦ÄÜ
ÊäÈë"2008-12-21 12:20:20"
Êä³ö"2008-12-21 12:00:00"

ÎÒдµÄÓÐÎÊÌâ


CREATE FUNCTION getdatehour(IDE date)
RETURN date as OED date;
BEGIN
OED:=cast(to_char(IDE,'YY')+'-'+to_char(IDE,'MM')+'-'+to_char(IDE,'DD')+' '+to_char(IDE,'HH24')+':00:00' as date);
return ODE;
END;

Ë­ÄܸøÎÒ¸öÕýÈ·µÄº¯Êý°¡

---

CREATE FUNCTION getdatehour(IDE date)
RETURN date as OED date;
BEGIN
OED:=substr(IDE,1,14)||00:00;
return ODE;
END;

---

CREATE OR REPLACE FUNCTION getdatehour(IDE date)
RETURN date
is
 OED date;
BEGIN
OED:=trunc(IDE,'hh');
return OED;
END;

select getdatehour(sysdate) from dual;

---

1Â¥±¨´í:

alter FUNCTION getdatehour(IDE date)
  *
ERROR 1 :
ORA-00922: 


SP2-0552: "00"

---

SQL code:

CREATE or replace FUNCTION getdatehour(IDE date)
RETURN date as
ODE date;
BEGIN
ODE := to_date(to_char(ide, 'yyyy-mm-dd hh24') || '00:00','yyyy-mm-dd hh24:mi:ss');
return ODE;
END;


²âÊÔ´úÂ룺
SQL code:

declare
d date := sysdate;
begin
d := getdatehour(d);
db