Re: [GENERAL] Substring Problem

[Tino Wildenhain]

[EMAIL PROTECTED] wrote:

Type casting is required since 8.3, try

SELECT substring(date :: varchar from 1 for 7) AS stryearmonth,

                     ^^^^^^

sorry but this hurts and should not recommended. I think depesz
approach with to_string() and the correct format string is the
better solution. (think of datetyle oddities) - one of the reasons
I believe most of the implicit casts have gone ayway.

COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY stryearmonth ORDER BY stryearmonth ASC

btw, whats the reason for the subselect?

T.

smime.p7s
Description: S/MIME Cryptographic Signature