https://forum.postgresql.org.pl/viewtopic.php?id=251 Wed, 15 Jul 2009 11:14:54 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=1058#p1058 Wed, 15 Jul 2009 11:14:54 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1058#p1058 https://forum.postgresql.org.pl/viewtopic.php?pid=1057#p1057 Wed, 15 Jul 2009 11:08:36 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1057#p1057 https://forum.postgresql.org.pl/viewtopic.php?pid=1056#p1056 query("select numer,to_char(REGD,'YYYY-MM-DD'),to_char(plans,'YYYY-MM-DD'), to_char(planf,'YYYY-MM-DD'),err_descr from tabela"); while($row = $stmt->fetch(PDO::FETCH_NUM)) { $pole=mb_convert_encoding($row[4],'win1250','UTF-8'); $pole=str_replace("\\",'-',str_replace("'",'-',$pole)); $stmp=$conn->query("INSERT INTO tabela1 (numer,reg_date,plan_s,plan_f,err_descr) VALUES ($row[0],to_date('$row[1]','YYYY-MM-DD'),to_date('$row[2]','YYYY-MM-DD'),to_date('$row[3]','YYYY-MM-DD'),'$pole')"); echo $row[0].' -- '. $row[1].' -- '. $row[2].' -- '. $row[3].' -- '. $row[4].'
'; }]]> Wed, 15 Jul 2009 11:06:43 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1056#p1056 https://forum.postgresql.org.pl/viewtopic.php?pid=1055#p1055 query("select numer,to_char(REGD,'YYYY-MM-DD'),to_char(plans,'YYYY-MM-DD'), to_char(planf,'YYYY-MM-DD'),err_descr from tabela"); while($row = $stmt->fetch(PDO::FETCH_NUM)) { $stmp=$conn->query("INSERT INTO tabela1 (numer,reg_date,plan_s,plan_f,err_descr) VALUES ($row[0],to_date('$row[1]','YYYY-MM-DD'),to_date('$row[2]','YYYY-MM-DD'),to_date('$row[3]','YYYY-MM-DD'),$row[4])"); echo $row[0].' -- '. $row[1].' -- '. $row[2].' -- '. $row[3].' -- '. $row[4].'
'; }]]> Wed, 15 Jul 2009 05:32:00 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1055#p1055