Pantech Jest

Pantech Jest is a CDMA slider with QWERTY keyboard. It is a feature phone that emphasizes on messaging and social networking through a dedicated My Messaging key. Navigation is done with an optical directional pad, and the camera is the meager 2MP. It targets the teenage crowd and its tendency to write insane amounts of texts, IMs and status updates. It looks well suited for that with its youthful looks, slider keyboard in black and orange, and dedicated buttons for messaging, music and snapshots.

Basic specifications:
CDMA 1900/800
Average Dimensions - 3.70 x 2.50 x 0.60 inches (94 x 64 x 15 mm)
Average Weight - 4.10 oz (116 g)
Standby / Talk times (358 h / 4.6 h)
2 megapixels Camera,  microSD/microSDHC slot
GPS - Yes

Samsung Epic 4G

Samsung Epic 4G is an Android 2,1 powered device heading for Sprint. It sports a full QWERTY keyboard, 4-inch Super AMOLED display, powerful 1GHz processor, 512MB of RAM, WiMAX connectivity and many more.

Basic specifications:
CDMA 1900/800
Big Dimensions - 4.90 x 2.54 x 0.56 inches (124 x 65 x 14 mm)
Heavy Weight - 5.46 oz (155 g)
Big display - 480 x 800 pixels; 16 777 216 colors
5 megapixels Camera,  microSD/microSDHC slot, 3G
   Android
GPS - Yes

Samsung Fascinate

Samsung Galaxy S Fascinate looks very similar to the Samsung Beam. It utilizes a large 4-inch WVGA Super AMOLED screen, a 1GHz processor and the Android 2.1 operating system. The camera is 5MP with option for 720p HD video recording at 30 frames per second. Other goodies include 3G, Wi-Fi, A-GPS, HD video playback, as well as playback for many other formats like FLAC, and MKV.

The pictures are of the Samsung Galaxy S I9000 and for illustration purposes only.

Basic specifications:
CDMA 1900/800
Big display - 480 x 800 pixels; 16 777 216 colors
5 megapixels Camera,  microSD/microSDHC slot, 3G
   Android
GPS - Yes

Samsung Vibrant

Samsung Vibrant is said to be the name of the Samsung GALAXY S for T-Mobile. Still, the device seems to have kept the GALAXY S branding on its back. It utilizes a large 4-inch WVGA, Super AMOLED screen, a 1GHz processor and the Android 2.1 operating system. The camera is 5MP with the ability to record 720p HD video at 30 frames per second. Other goodies include 3G, Wi-Fi and A-GPS

Basic specifications:
GSM 850/900/1800/1900
UMTS 2100/1700
Average Dimensions - 4.82 x 2.54 x 0.39 inches (122 x 65 x 10 mm)
Average Weight - 4.16 oz (118 g)
Big display - 480 x 800 pixels; 16 777 216 colors
Standby / Talk times (450 h / 6.5 h)
5 megapixels Camera,  microSD/microSDHC slot, 3G
   Android
GPS - Yes

LG Prime

LG Prime GS390 is a GoPhone for AT&T which comes in a candybar form factor and features a 3" QVGA touchscreen display, 2-megapixel camera, support for mobiTV mobile television service and microSD card slot.

Basic specifications:
GSM 850/900/1800/1900
Average Dimensions - 4.25 x 2.08 x 0.50 inches (108 x 53 x 13 mm)
Light Weight - 3.14 oz (89 g)
Average display - 240 x 400 pixels; 262 144 colors
Standby / Talk times (384 h / 4 h)
2 megapixels Camera,  microSD/microSDHC slot

Samsung B2710

Samsung B2710 appears to be a rugged candybar phone with not so impressive set of features including a 2.0 inch display, 2 megapixel camera, Music player, compass, altimeter, pedometer etc.

Basic specifications:
GSM 850/900/1800/1900
UMTS 2100/900
Average Dimensions - 4.11 x 1.96 x 0.73 inches (104.4 x 49.9 x 18.6)
Average Weight - 4.06 oz (115 g)
Average display - 240 x 320 pixels; 262 144 colors
2 megapixels Camera,  microSD slot, 3G

Datetime Function SWITCHOFFSET Example - SQL Server

It returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset.

What essentially it does is that changes the current offset of the time to any other offset which we defined. Let us see the example of the same.

SELECT SYSDATETIMEOFFSET() GetCurrentOffSet;
SELECT SWITCHOFFSET(SYSDATETIMEOFFSET(), '-04:00') 'GetCurrentOffSet-4';
SELECT SWITCHOFFSET(SYSDATETIMEOFFSET(), '-02:00') 'GetCurrentOffSet-2';
SELECT SWITCHOFFSET(SYSDATETIMEOFFSET(), '+00:00') 'GetCurrentOffSet+0';
SELECT SWITCHOFFSET(SYSDATETIMEOFFSET(), '+02:00') 'GetCurrentOffSet+2';
SELECT SWITCHOFFSET(SYSDATETIMEOFFSET(), '+04:00') 'GetCurrentOffSet+4';

Now let us check the resultset of the same.

The example above clearly shows that Switch offset does not only change the offset; it also alters the current time. If you look at GetcurrentOffset, it is +5.30; but, you will notice that GetCurrentOffset-2 does not only change the offset to -2. It also changes the time with the appropriate time at Timezone -2.

I suggest that you run the code in SSMS Query Window and observe the code behavior.

Source: Pinal Dave