summaryrefslogtreecommitdiffstats
path: root/debian/uncrustify-trinity/uncrustify-trinity-0.76.0/tests/input/sql/issue_527.sqc
blob: 5514ff319952a841bc9aafc6573bb429dbd72ec7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
void myfunc1()
{
    EXEC SQL create or replace
        function my_func (in_str IN varchar2)
        return date
        IS
        x date;
    BEGIN
    IF in_str IS NULL THEN
        x:  = NULL;
    ELSIF substr(in_str, 5,  1) = '-' THEN
    x := to_date(in_str, 'YYYY-MM-DD HH24:MI:SS');
    END IF;
    return x;
    END my_func;
    END-EXEC;
}