www.fromthevalley.com.au

Varchar to int CAST

 

 To use int based functions, you must cast the varchar to an int/double first.

 

ie:  select sum(value::double precision) from table;

 

 

HOMEAJAXAPACHEBizphoneCSSDNSGeneralGraphicsHTMLHardwareJavascriptLinuxMACMS SQLMailMicrosoftOFFICE 365PerlPostgresSEOSocial MediaVMwareWindows 10