Changeset a299aee in tol for tolbase/lib

Timestamp:

Nov 25, 2008, 10:13:04 AM (18 years ago)

Author:

Jaime García <jgarcia@…>

Branches:

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

Children:

7ffc18f

Parents:

54127e4

Message:

PostGre date format error solved

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

File:

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

tolbase/lib/byswidget/bfunctions/bfsql.tcl

@@ -339 +339 @@
           "Mic" { set valFor "convert(datetime,'${value}',121)"            }
           "Ora" { set valFor "to_date('${value}','YYYY-MM-DD HH24:MI:SS')" }
-          "Pos" { set valFor "to_date('${value}','YYYY-MM-DD HH24:MI:SS')" }
+          "Pos" { set valFor "to_date('${value}','YYYYMMDD HH24:MI:SS')" }
           "Mys" { set valFor "str_to_date('${value}','%Y%m%d %H:%i:%s')" }
           default { error "Gestor no implementado $gestor"  }
@@ -419 +419 @@
         }
         "Pos" {
-          set delimeter {{to_date('} {','YYYY-MM-DD HH24:MI:SS')}}        
+          set delimeter {{to_date('} {','YYYYMMDD HH24:MI:SS')}}        
         }
         default { error "Variable DBA (Gestor) not defined"  }