Differences

This shows you the differences between two versions of the page.

--- kurs:typkonvertierung_-_casten [2008/10/29 09:50]
mh created
+++ kurs:typkonvertierung_-_casten [2016/11/30 11:14]
admin
@@ Line 1: / Line 1: @@
+<code>
+select to_char(to_date('2006', 'yyyy'), 'yyyymmdd hh24:mi:ss') from dual;
+</code>
+<code>
+CREATE OR REPLACE FUNCTION TRY_TO_NUMBER
+(p_val in varchar2)
+RETURN NUMBER AS
+  v_number number;
+BEGIN
+  begin
+    v_number := to_number(p_val);
+    exception
+      when VALUE_ERROR then
+      v_number := 0;
+   end;
+   return v_number;
+END TRY_TO_NUMBER;
+</code>

dokuwiki