import java.sql.*;
import java.util.*;
public class SQL2k5 {

    public static void main  (String[] args) throws Exception{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
       Connection conn = DriverManager.getConnection("jdbc:sqlserver://<Server>;user=<UserId>;password=<Password>;database=<DatabaseName>");
               DatabaseMetaData dbmd = conn.getMetaData();
               System.out.println("Driver version is " + dbmd.getDriverVersion() );

               Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
               try {stmt.executeUpdate("drop table TimeZoneTable");}
               catch (Exception e) {}
               stmt.executeUpdate("create table TimeZoneTable (col1 datetime)");

               ResultSet rs;

               TimeZone.setDefault(TimeZone.getTimeZone("America/Los_Angeles"));
               System.out.println("My time zone is " + TimeZone.getDefault());

               stmt.executeUpdate("insert into TimeZoneTable (col1) values (N'4/2/2006 02:00:00.008')");	

               rs = stmt.executeQuery("select cast (col1 as char(25)) from TimeZoneTable");
               rs.next();
               System.out.println("\nTime from database (as string): " + rs.getString(1));	
               rs = stmt.executeQuery("select col1 from TimeZoneTable");
               rs.next();
               System.out.println("Returned time with no Calendar: " + rs.getTimestamp(1));
               System.out.println("Returned time with America/New_York Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("America/New_York"), Locale.US)));
               System.out.println("Returned time with America/Phoenix Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("America/Phoenix"), Locale.US)));
               System.out.println("Returned time with America/Denver Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("America/Denver"), Locale.US)));
               System.out.println("Returned time with America/Indianapolis Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("America/Indianapolis"), Locale.US)));
               System.out.println("Returned time with Pacific/Honolulu Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("Pacific/Honolulu"), Locale.US)));

    }
}