postgresql 9.1 - Query for taking data between two specific months and two specific year in postgressql -


i want data between month1 year1 month2 year2

example jan 2016 jan 2017.

i have query like

select * customer cr   extract(month cr.regdate) between month1 , month2 ,   extract(year cr.regdate) between year1 , year2

this query giving wrong result when take data jan 2016 jan 2017. expecting data jan 2016, feb 2016, mar 2016 till jan 2017. giving result jan 2016 , jan 2017. please guide me.


Comments

Post a Comment

Popular posts from this blog

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

javascript - pass values from mssql to views in node -

being new node js , javascript . have been trying find solution problem . this app.js file var express=require ('express'); var bodyparser = require('body-parser'); var path = require ('path'); var sql = require('mssql'); var app = express(); const config = { user: 'sa', password: 'password', server: 'localhost\\sqlexpress', // can use 'localhost\\instance' connect named instance database: 'pcgdb', options: { encrypt: false // use if you're on windows azure } }; const request = new sql.request() //view engine app.set('view engine', 'ejs'); app.set('views', path.join(__dirname, 'views')) app.use(bodyparser.json()); app.use(bodyparser.urlencoded({extended: false})); app.get('/',function(req,res){ res.render('index') }); app.get('/new_project', function(req, res) { function(data,err){ ...
Read more

image - python get coordinates (pixels) of corresponding points from clicks -

this question has answer here: store mouse click event coordinates matplotlib 2 answers detecting mouse event in image matplotlib 2 answers determine button clicked subplot in matplotlib 2 answers i have 2 images want following using python 3.6 1- plot both images side side 2- click on 1 image , output corresponding pixel coordinates 3- click on second image , corresponding pixel coordinates note: question different because has work on 2 images finding axis click event happening. i think best way have function identifies axis clicking on , gets clicked coordinates. couldn't find of resources 2 images, found on 1 image.
Read more