Return date as ddmmyyyy in SQL Server -

-

i need date ddmmyyyy without spacers.

how can this?

i can yyyymmdd using convert(varchar, [mydatetime], 112)

but need reverse of this.

sql server 2008

convert style 103 dd/mm/yyyy. use replace function eliminate slashes.

select replace(convert(char(10), [mydatetime], 103), '/', '')

Comments

Post a Comment

Popular posts from this blog

jQuery Ajax Render Fragments OR Whole Page -

-
i'm in throes of building application wraps mess of legacy code. page working on, need substitute fragment divs constructed on back-end -- or else need replace entire page altogether. idea there dynamically controlled flow needs satisfied before can forward legacy product. substituting fragments works fine, seen in below my_body_content swap. trouble comes when i'm trying render not fragment, whole page, in "body" swap. @ point page goes blank. i want similar errors returned server. want nice rest 404 error messages displayed on screen, legacy-product 404s show in legacy-product 404 page. yes, requirements project weird. that's not problem can fix. here's jquery invocation, names changed protect guilty: $.ajax({ url: "places/things", type: "post", data: json.stringify(somebadassobject), datatype: "text", accepts: "text/html", contenttype: "application/json; charset=...
Read more

Jquery & Rails 3: Run controller action from js file? -

-
i click div on page run number of javascript tasks, run action on controller. explain in greater detail: i have untitled.js file in have put bunch of jquery code : $(function(){ $('nav li').hover(function(){ $(this).addclass("bigger", 50); }, function(){ $(this).removeclass("bigger", 50); }); $('#notify').click(function(){ $('.notifications').show(); }); $('#notify').click(function(){ (some code run controller action) }); }); i run controller action called "run_tasks" on "users" controller when #notify button clicked, showing notifications class. can see in above code have jquery code showing .notifications sorted out, don't know put in "(some code run controller action)". provide information controller action, run tasks want run, doesn't redirect new page or anything. here basic format of users controller: class userscontroller < applicati...
Read more

jquery - Creating xls in javascript using ActiveXObject -

-
my code var fsobj = new activexobject("scripting.filesystemobject"); var excelapp = new activexobject("excel.application"); excelapp.displayalerts = false; var wbobj = excelapp.workbooks.add; var wsobj = wbobj.worksheets(1); when use below code works fine (i.e., executes excel , fills in 2 rows) wsobj.cells(1,1).value="hello"; wsobj.cells(2,1).value=comparedata.response.length; wbobj.application.visible=true; but when use below code says expected ';' in 3rd line (with hello), not able find problem here. here jsfiddle link, not working though, if can make work for(i=0;i<comparedata.response.length;i++) { wsobj.cells(i,1).value="hello"; } wbobj.application.visible=true; row numbers in excel start 1, not 0. should write for(i=0; i<comparedata.response.length; i++) { wsobj.cells(i + 1, 1).value="hello"; }
Read more