at the end of any product there will be a reporting interfaces for counts. let say you build a advertisement site which gives people to publish their products on the site. they will want to see how many people visited their product in daily basis or weekly. I used to do this in mysql like this SELECT create_time as Date, count(id) as 'Count', FROM views_of_product group by date_format(create_time, '%d %m %Y') order by date_format(create_time, '%Y-%m-%d') desc limit 7 this will nicely show last seven days views. but I needed to do same thing in postgresql. and like other days its not easily to find. I should check other report codes from project but no I allways research on google :) anyway here is my code: select to_char(created, 'YYYY-MM-DD') ,count(id) from videos_capture group by to_char(created, 'YYYY-MM-DD') order by to_char(created, 'YYYY-MM-DD') desc limit 7 its not bad actually works like a charm but understanding this
Popular posts from this blog
I don't know what is going on but there is strange things happening about Alexa these days. I have been buying some text links for seo for Google but some how my site loosing its score from Alexa its simply impossible because traffic going up. but when I see that Google ranked as 4. in Alexa top list I understand that there must be some thing going on Alexa. I dunno what its yet. it may be changing its algorithm or something. but it effects even Google . think about it.....
belki 100 kere yazmışımdır yine unuttum yine not alıom ingilizcesi: qwinsta /server:188.8.131.52 Where 184.108.40.206 is the IP address or name of the non-accessible machine. This will display something like this: > qwinsta /server:220.127.116.11 SESSIONNAME USERNAME ID STATE TYPE DEVICE console 0 Conn wdcon rdp-tcp 65536 Listen rdpwd rdp-tcp#470 Bob 1 Active rdpwd rdp-tcp#471 Jane 3 Active rdpwd Now I know that Bob and Jane are the two that are logged in. Since Jane left the office 20 minutes ago I know that she forgot to log off. I don't know where Bob is but I only need one session so I'll ignore him for now. To disconnect Jane's session I would type this: rwinsta /server:18.104.22.168 3 türkçeside: qwinsta /server:ipadres ile sorgu çekersin rwinsta /server:ipadresi sessionID ilede açık kalmış olan se