sql - DB2 date format day leading zero -

-

how can remove leading 0 day in query?

it returns e.g. "mar 02" when use this:

select varchar_format(mydatefield, 'mon dd') mytable

i need "mar 2"

there doesn't seem particular format days without leading zeros. so, 1 option is:

select replace(varchar_format(mydatefield, 'mon dd'), ' 0', ' ')

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

amazon web services - Installing MobileFirst 7.0 server on AWS -

-
are there instructions installing mobilefirst server 7.0 on aws ec2(amazon web services). found article ( https://www.ibm.com/developerworks/community/blogs/worklight/entry/how_to_install_worklight_server_on_amazon_ec21?lang=en ), seems outdated latest versions. appreciate if has generic document installing mobilefirst on cloud services aws. mobilefirst platform foundation 7.0 not different worklight 6.2 etc, it's same new features, etc. you setup account ec2 vm, running linux, , mfpf supports linux. nothing different perspective. meaning, blog post you've found true mfpf 7.0.
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