FreeBSD Bugzilla – Attachment 123334 Details for
Bug 166662
www/asterisk-stat - pgsql select substring() problem
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
[patch]
file.diff
file.diff (text/plain), 606 bytes, created by
vess
on 2012-04-05 09:20:08 UTC
(
hide
)
Description:
file.diff
Filename:
MIME Type:
Creator:
vess
Created:
2012-04-05 09:20:08 UTC
Size:
606 bytes
patch
obsolete
>--- call-log.php.orig 2012-04-05 10:48:18.000000000 +0300 >+++ call-log.php 2012-04-05 10:48:29.000000000 +0300 >@@ -229,7 +229,7 @@ > > > /************************/ >- $QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)"; //extract(DAY from calldate) >+ $QUERY = "SELECT substr(cast(calldate as text),1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substr(cast(calldate as text),1,10)"; //extract(DAY from calldate) > //echo "$QUERY";
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=123334">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 166662
: 123334 |
123335