RED + GREEN + BLUE = COLOR

<font color=red>Red Color</font>

<font color=#FF0000>Red Color</font>

C:\Users\mkyong\Documents\My Games\Crysis

to_date(text,text)

CREATE TABLE n_url_test
(
  urltestid bigserial NOT NULL,
  createddate timestamp without time zone DEFAULT now(),
  CONSTRAINT n_url_to_test_pkey PRIMARY KEY (urltestid)
)

--PostgreSQL 8.2
---------------
SELECT  to_date(createddate,'YYYY-MM-DD') FROM n_url_test;

--PostgreSQL 8.3
---------------
SELECT  to_date(createddate,'YYYY-MM-DD') FROM n_url_test;
 
--------------------------------------------------------------------------------
ERROR:  FUNCTION to_date(timestamp without time zone, unknown) does NOT exist
LINE 1: SELECT  to_date(createddate,'YYYY-MM-DD') FROM n_url_test
                ^
HINT:  No FUNCTION matches the given name AND argument types. 
You might need TO ADD explicit type casts.
 
********** Error **********

--PostgreSQL 8.3
---------------
SELECT  to_date(createddate::text,'YYYY-MM-DD') FROM n_url_test;

response.setContentType("application/octet-stream");
response.setHeader("Content-Disposition",
"attachment;filename=downloadfilename.csv");

File file = new File("C:\\temp\\downloadfilename.csv");
FileInputStream fileIn = new FileInputStream(file);
ServletOutputStream out = response.getOutputStream();
 
byte[] outputByte = new byte[4096];
//copy binary contect to output stream
while(fileIn.read(outputByte, 0, 4096) != -1)
{
	out.write(outputByte, 0, 4096);
}
fileIn.close();
out.flush();
out.close();

StringBuffer sb = new StringBuffer("whatever string you like");
InputStream in = new ByteArrayInputStream(sb.toString().getBytes("UTF-8"));
ServletOutputStream out = response.getOutputStream();
 
byte[] outputByte = new byte[4096];
//copy binary contect to output stream
while(in.read(outputByte, 0, 4096) != -1)
{
	out.write(outputByte, 0, 4096);
}
in.close();
out.flush();
out.close();

public ActionForward export(ActionMapping mapping, ActionForm form,
	HttpServletRequest request, HttpServletResponse response)
	throws Exception {
 
	//tell browser program going to return an application file instead of html page
      response.setContentType("application/octet-stream");
      response.setHeader("Content-Disposition","attachment;filename=temp.csv");
 
		try 
		{
			ServletOutputStream out = response.getOutputStream();
			StringBuffer sb = generateCsvFileBuffer();
 
			InputStream in = new ByteArrayInputStream(sb.toString().getBytes("UTF-8"));
 
 
			byte[] outputByte = new byte[4096];
			//copy binary contect to output stream
			while(in.read(outputByte, 0, 4096) != -1)
			{
				out.write(outputByte, 0, 4096);
			}
			in.close();
			out.flush();
			out.close();
 
		}
		return null;
	}
 
private static StringBuffer generateCsvFileBuffer()
{
	StringBuffer writer = new StringBuffer();
 
		writer.append("DisplayName");
		writer.append(',');
		writer.append("Age");
		writer.append(',');
		writer.append("HandPhone");
		writer.append('\n');
 
            writer.append("mkyong");
		writer.append(',');
		writer.append("26");
		writer.append(',');
		writer.append("0123456789");
		writer.append('\n');
 
 
		return writer;
}

Display Name,   Age, Hand Phone
Micheal , 30, 0123456789
Bill, 25, 0129876543

package com.mkyong.test;
 
import java.io.FileWriter;
import java.io.IOException;
 
public class GenerateCsv
{
   public static void main(String [] args)
   {
	   generateCsvFile("c:\\test.csv"); 
   }
 
   private static void generateCsvFile(String sFileName)
	{
		try
		{
		    FileWriter writer = new FileWriter(sFileName);
 
			writer.append("DisplayName");
			writer.append(',');
			writer.append("Age");
			writer.append('\n');
 
			writer.append("MKYONG");
			writer.append(',');
			writer.append("26");
			writer.append('\n');
 
			writer.append("YOUR NAME");
			writer.append(',');
			writer.append("29");
			writer.append('\n');
 
			//generate whatever data you want
 
			writer.flush();
			writer.close();
		}
		catch(IOException e)
		{
		 e.printStackTrace();
		} 
	}
}

cat /proc/cpuinfo

debian:~# cat /proc/cpuinfo
processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 15
model name      : Intel(R) Core(TM)2 CPU          6300  @ 1.86GHz
stepping        : 8
cpu MHz         : 1861.324
cache size      : 2048 KB
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                                                   pat pse36 clflush dts acpi mmx fxsr sse sse2 ss nx lm constant_tsc up pni ds_cpl                                                                                                   cx16 lahf_lm
bogomips        : 3734.51

 <bean id="testAutoProxyCreator"
		class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
		<property name="interceptorNames">
			<list>
				<idref bean="urlInterceptorInsert" />
				<idref bean="urlInterceptorCommit" />
				<idref bean="urlInterceptorRelease" />
			        <idref bean="matchGenericTxInterceptor" />
			</list>
		</property>
		<property name="beanNames">
			<list>
				<idref local="urlBo" />
			</list>
		</property>
	</bean>

<idref bean="matchGenericTxInterceptor" />

<idref bean="urlInterceptorInsert" />
<idref bean="urlInterceptorCommit" />
<idref bean="urlInterceptorRelease" />

 <bean id="testAutoProxyCreator"
		class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
		<property name="interceptorNames">
			<list>
                                <idref bean="matchGenericTxInterceptor" />
				<idref bean="urlInterceptorInsert" />
				<idref bean="urlInterceptorCommit" />
				<idref bean="urlInterceptorRelease" />
			</list>
		</property>
		<property name="beanNames">
			<list>
				<idref local="urlBo" />
			</list>
		</property>
	</bean>

SHOW search_path

#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------
 
# - Statement Behavior -
 
#search_path = '"$user",public'		# schema names
#default_tablespace = ''		# a tablespace name, '' uses
					# the default
#check_function_bodies = on
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = off

SET search_path = new_schema

#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------
 
# - Statement Behavior -
 
#search_path = '"$user",public'		# schema names
search_path = '"$user",new_schema'	# NEW SCHEMA HERE
#default_tablespace = ''		# a tablespace name, '' uses
					# the default
#check_function_bodies = on
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = off