Posts Tagged date
Generate Date from a range in Mysql and pad the results where no date is present
If you want to generate dates, MYSQL doesn’t have a range function, so I wrote a work around for the same. So how it works is I have reused a code to generate numbers from my previous post. So I added date function to that query and reduce the generated numbers from the date. Hence effectively its Currrent Date – x number of days. Thus we generate the dates from the date we provide to the x number we generate. So here is the code:
Group by Date when Stored in Mysql DataBase as Date Time
I have a table called date_count with 2 columns one is a value and another is a date time, say called date_time in mysql. Date Time in mysql is stored as dd-mm-yy hh:mm:ss. The issue comes when I need to get the number of rows per day. As its stored as date time format in mysql , you need to specify both date and time when you specify a group by. So grouping by day is not possible in that case. So we need to use the in-build mysql function DATE(). The function accepts date time as parameter and returns only date back. So we just need to use the DATE() function where we need to group by date and all the date time values are converted to date and can be grouped by date. So here is the implementation of it.
Continue reading “Group by Date when Stored in Mysql DataBase as Date Time” »
Change Timezone in Linux from command line
Changing the timezone in linux is done in a weird method. There is no configuration file where you can edit and change timezone. The method is simple and very easy. You need to link to the timezone you need. Find the timezone file you need in /usr/share/zoneinfo/. Go to correct folder and find the place nearest to you( or with the correct timezone). Now link it to the /etc/localtime with the following command example
Continue reading “Change Timezone in Linux from command line” »
Customizing Mysql Prompt For multiple Servers
If you are using mysql regularly on multiple servers its really useful to have the promt in mysql to show something more than mysql>. It would be useful if it showed the username,hostname, current database and things like that.
So how to do this.
Continue reading “Customizing Mysql Prompt For multiple Servers” »
Automatic Desktop Wallpaper Changer for Linux
Posted by Srijith R in gnome, linux, shell scripting on November 16, 2008
I have a lot of wallpaper that I wanted to switch automatically. After a lot of search i found that there a command way to control all the gnome settings. So I the command I used is “gconftool-2“.
So code is like:
Continue reading “Automatic Desktop Wallpaper Changer for Linux” »
Automatic Command Archive
Posted by Srijith R in linux, shell scripting on September 7, 2008
The default command storing size of ubuntu is 500 commands. It stores the commands in home folder in the file “.bash_history” .
The problem is 500 commands is too short of a size.
One method is to increase the command size to a large value by changing the $HISTFILESIZE variable using the following command
Continue reading “Automatic Command Archive” »
Recent Comments