sql - How to fetch data from a query by extracting month from the created date field -


i have table , want extract data on basis of month value of created date field. how can obtained? here query:

select * (table name a) select extract (month a.createddate )from table name

table contains field timestamp type.

if need apply filter on month of timestamp column:

select * yourtable extract (month yourfield) = ...

-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

linux - gzip: stdin: not in gzip format tar: Child returned status 1 tar: Error is not recoverable: exiting now -

i have bash script creates tar.gz , encrypts sends drive. cannot open .tar.gz afterwards. here process... bash script encrypts. #!/bin/sh # tar automysqlbackup directory tar -zcf "red-backup-$(date '+%y-%m-%d').tar.gz" /var/lib/automysqlbackup/ # encrypt tar openssl aes-256-cbc -a -salt -in "red-backup-$(date '+%y-%m-%d').tar.gz" -out "red-backup-$(date '+%y-%m-%d').tar.gz.enc" -pass 'pass:mysecretpwd' # remove original tar rm -rf "red-backup-$(date '+%y-%m-%d').tar.gz" # upload google drive gdrive upload --file "red-backup-$(date '+%y-%m-%d').tar.gz.enc" -p "jofhriout849uioejfoiu09" then download file , use sudo openssl aes-256-cbc -e -in red-backup-2016-09-22.tar.gz.enc -out red-backup-2016-09-22.tar.gz i enter passphrase file twice , file called red-backup-2016-09-22.tar.gz when try sudo tar -zxvf red-backup-2016-09-22.tar.gz and gzip: stdin: not ...
Read more

delphi - Disable and change color of node in Treeview -

Image
i looking way of disabling proper nodes . let's have created simple treeview structure below: parent 1 (disable) parent 2 child 1 child 2 (disable) so far have found workaround how that, still doesn't work @ all. use onchanging event handler: procedure tform1.treeviewchanging(sender: tobject; node: ttreenode; var allowchange: boolean); begin if (node.text = 'parent 1') or (node.text = 'child 1') allowchange := false; end; it works, because can't click on node, issue after 'disabling' node way, color of parent 1 , child 1 nodes same other. way change color of nodes (grey)? or maybe know way disabling nodes in ttreeview component? to disable node, set enabled property false . disabled item displayed in gray color. to change normal color of nodes text, change ttreeview.font.color . to change color of disabled nodes text, use oncustomdrawitem event: procedure tform2.treeview1customdrawitem(sender: tcu...
Read more