Changeset db6cf9c in tol for tolbase/lib/byswidget/bfunctions/bfsql.tcl

Timestamp:

Nov 12, 2008, 9:22:46 AM (18 years ago)

Author:

Jaime García <jgarcia@…>

Branches:

1941-docker-image-to-test, devel, master

Children:

d7768ed

Parents:

5ed3b7e

Message:

posGre error solved

git-svn-id: ​https://www.tol-project.org/svn/tolp/trunk@148 be4846ae-f051-483a-831f-b64e7d08527f

File:

• tolbase/lib/byswidget/bfunctions/bfsql.tcl (modified) (3 diffs)

tolbase/lib/byswidget/bfunctions/bfsql.tcl

@@ -338 +338 @@
         switch $gestor {
           "Mic" { set valFor "convert(datetime,'${value}',121)"            }
-          "Ora" - "Pos"{ set valFor "to_date('${value}','YYYY-MM-DD HH24:MI:SS')" }
+          "Ora" { set valFor "to_date('${value}','YYYY-MM-DD HH24:MI:SS')" }
+          "Pos" { set valFor "to_date('${value}','YYYY-MM-DD HH24:MI:SS')" }
           "Mys" { set valFor "str_to_date('${value}','%Y%m%d %H:%i:%s')" }
           default { error "Gestor no implementado $gestor"  }
@@ -357 +358 @@
     }
   }
+  
+  Tolcon_Trace "valFor --> $valFor"  
   return $valFor
 }
@@ -412 +415 @@
           set delimeter {{convert(datetime,'} {',121)}}        
         }
-        "Oracle" - "Pos" {
+        "Oracle" {
+          set delimeter {{to_date('} {','YYYY-MM-DD HH24:MI:SS')}}        
+        }
+        "Pos" {
           set delimeter {{to_date('} {','YYYY-MM-DD HH24:MI:SS')}}        
         }