Re: [SQL] No output while using PEAR DB & formatted time-string

Am 01.11.2003 12:00 meinte Marcus Krause: > $query .= "SELECT news_id,to_char(news_time,'DD.MM. HH24:MI'), "; The real code is without the comma at the end of the line above, so it's not a simple SQL-Statement problem! ---(end of broadcast)---

[SQL] No output while using PEAR DB & formatted time-string

I have a problem in using the to_char function in a SQL-Statement and addressing it with DB_FETCHMODE_OBJECT under PEAR DB. The follwing code is working fine unless I'm adding the to_char function: -- require_once 'DB.php'; $dsn = $$$; $