Jaunumi e-pastā
Valūtas kursi
0,7028 no change
0,0177 no change
0,5340 up
plašāk..
ERROR: function to_date(timestamp without time zone, unknown) does not exist LINE 1: SELECT xml.id, to_date(t_value,'YYYY-MM-DD') AS view_date FR... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
SELECT xml.id, to_date(t_value,'YYYY-MM-DD') AS view_date FROM xml JOIN xml_attributes a ON a.xml_id=xml.id WHERE name='view_date' AND (t_value = to_date('2012-02-06','YYYY-MM-DD') OR t_value = to_date('2012-02-07','YYYY-MM-DD') OR t_value = to_date('2012-02-08','YYYY-MM-DD')) ORDER BY view_date
#0 /srv/www/v.hosts/media_elements/ntz.lv/classes/Page.php(509): PgDB->rsOpen('SELECT xml.id, ...', true, 720, Array)
#1 /srv/www/v.hosts/media_elements/ntz.lv/classes/objs/pub/Weather.php(35): Page->rsOpen('SELECT xml.id, ...', true, 720)
#2 /srv/www/v.hosts/media_elements/ntz.lv/classes/objs/pub/Weather.php(13): Weather->xmllist()
#3 /srv/www/v.hosts/media_elements/ntz.lv/classes/RamuneSmarty.php(139): Weather->load()
#4 /srv/www/v.hosts/media_elements/ntz.lv/wwwroot/tmpl_c/%%96^963^963BB0F9%%portlets.tpl.php(10): ramune_register_object(Array, Object(RamuneSmarty))
#5 /srv/www/v.hosts/media_elements/ntz.lv/smarty/Smarty.class.php(1265): include('/srv/www/v.host...')
#6 /srv/www/v.hosts/media_elements/ntz.lv/classes/Tmpl.php(127): Smarty->fetch('/srv/www/v.host...')
#7 /srv/www/v.hosts/media_elements/ntz.lv/classes/Page.php(287): Tmpl->ssTmpl('portlets', Array)
#8 /srv/www/v.hosts/media_elements/ntz.lv/classes/objs/pub/Portlets.php(70): Page->ssTmpl('portlets', Array)
#9 /srv/www/v.hosts/media_elements/ntz.lv/classes/RamuneSmarty.php(139): Portlets->load()
#10 /srv/www/v.hosts/media_elements/ntz.lv/wwwroot/tmpl_c/%%07^072^072C752B%%default.tpl.php(23): ramune_register_object(Array, Object(RamuneSmarty))
#11 /srv/www/v.hosts/media_elements/ntz.lv/smarty/Smarty.class.php(1265): include('/srv/www/v.host...')
#12 /srv/www/v.hosts/media_elements/ntz.lv/classes/Core.php(254): Smarty->fetch('/srv/www/v.host...')
#13 /srv/www/v.hosts/media_elements/ntz.lv/classes/Core.php(351): Core->smartyLoad(Array)
#14 /srv/www/v.hosts/media_elements/ntz.lv/wwwroot/index.php(162): Core->load()
#15 {main}