1 PACKAGE hr_date AUTHID CURRENT_USER AS
2 /* $Header: hrutldtw.pkh 120.1 2005/06/15 02:42:27 sturlapa noship $ */
3
4 -- ------------------------------------------------------------------------
5 -- chardate_to_date
6 -- takes a character in display format and return a date
7 -- ------------------------------------------------------------------------
8 FUNCTION chardate_to_date
9 (p_chardate in varchar2)
10 RETURN date;
11
12 -- ------------------------------------------------------------------------
13 -- date_to_chardate
14 -- convert date to display format
15 -- ------------------------------------------------------------------------
16 FUNCTION date_to_chardate
17 (p_date in date)
18 RETURN varchar2;
19
20 -- ------------------------------------------------------------------------
21 -- date_to_canonical
22 -- convert date to canonical format 'YYYY/MM/DD'
23 -- ------------------------------------------------------------------------
24 FUNCTION date_to_canonical
25 (p_date in date)
26 RETURN varchar2;
27
28 -- ------------------------------------------------------------------------
29 -- canonical_to_date
30 -- convert canonical date 'YYYY/MM/DD' to Oracle date
31 -- ------------------------------------------------------------------------
32 FUNCTION canonical_to_date
33 (p_canonical in varchar2)
34 RETURN date;
35
36 -- ------------------------------------------------------------------------
37 -- chardate_to_canonical
38 -- take a character in display format and return a canonical date 'YYYY/MM/DD'
39 -- ------------------------------------------------------------------------
40 FUNCTION chardate_to_canonical
41 (p_chardate in varchar2)
42 RETURN varchar2;
43
44 -- ------------------------------------------------------------------------
45 -- canonical_to_chardate
46 -- convert canonical date 'YYYY/MM/DD' to chardate in display format
47 -- ------------------------------------------------------------------------
48 FUNCTION canonical_to_chardate
49 (p_canonical in varchar2)
50 RETURN varchar2;
51
52 END hr_date;
[Home] [Help]