| Help me with date and datetime items! [message #85295] |
Mon, 14 June 2004 04:56  |
Solveiga
Messages: 36
Registered: March 2003
|
Member |
|
|
Could someone help me with such a function?
I created functio FD:
FUNCTION FD (date1 Date, date2 Date) RETURN DATE IS d Date;
BEGIN
d := to_date(to_char(data1,'yyyy-mm-dd')||' '||to_char(data2,'hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss');
return(d);
END;
and want to format a data base item by writing
:My_block.Date_item := FD(:My_block.Day, :My_block.Time)
Could someone help me?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
