SQL Server convert date to String MMMYYDD -

-

im trying convert date value mmmyydd string format, using native sql server 2008 r2 function,

i checked here http://www.sql-server-helper.com/tips/date-formats.aspx

and still can't find matching format.

any ideas?

something this?

select convert(varchar(3), @date, 7) + convert(varchar(4), @date, 12)

sql fiddle demo


Comments

Post a Comment

Popular posts from this blog

node.js - How to mock a third-party api calls in the backend -

-
i'm testing application mocha , supertest, test like var request = require('supertest'), app = require('./bootstrap.js'); describe('...', function() { it('...', function() { request(app) .get('/some/url') // ... }); }); the bootstrap.js real application before listen ports all works perfect have add calls third-party api , testing slow so when do, test example takes 5 seconds request(app) .get('/my/endpoint/that/makes/call/others') // ... how can make fake calls during test real when running application? you can use nock purpose.
Read more

java - Could not locate OpenAL library -

-
i writing game using slick2d library, uses lwjgl. lwjgl version 2.9.3. using netbeans 8. i tried adding sounds game, example music track on main menu. problem is, exception when run game, despite game still compiling , running except sound of course: sat mar 21 01:23:57 edt 2015 error:could not locate openal library. org.lwjgl.lwjglexception: not locate openal library. @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:102) @ org.lwjgl.openal.al.create(al.java:206) @ org.newdawn.slick.openal.soundstore$1.run(soundstore.java:295) @ java.security.accesscontroller.doprivileged(native method) @ org.newdawn.slick.openal.soundstore.init(soundstore.java:292) @ org.newdawn.slick.music.<init>(music.java:156) @ org.newdawn.slick.music.<init>(music.java:75) @ view.mainmenu.init(mainmenu.java:58) i didn't include rest of error states error happens in game code. the...
Read more

Non Unique Username with ASP.Net Identity 2.0 -

-
i have situation username not unique. email used username , 1 email can have many different passwords in database , legitimate. how use asp.net identity 2.0 in situation. var result = await signinmanager.passwordsigninasync(model.username, model.password, model.rememberme, shouldlockout: false); above line expects 1 user in database. if multiple records returned - returns failure. expected logic doesn't work me. how override logic? alternatively, ready customize login problem - not sure things done part of passwordsigninasync. adding cookies etc. please help. i made work. had use username + password combination unique username. these different situations in industry different types of needs.
Read more