remove obsolete aliases

[z_archive/dotfiles.git] / .bash_aliases

diff --git a/.bash_aliases b/.bash_aliases
index 7bed065d10b9fe707035e479791ea310059523ea..e6eef33f2fe4960c82d567cc39e7db35bcd7493b 100755 (executable)
--- a/.bash_aliases
+++ b/.bash_aliases
@@ -13,7 +13,5 @@ alias grep='grep --color=auto'
 alias http='http -p HBhb'
 alias last='last -w'
 alias radlast='radlast -w'
-alias checkhours="echo 'SELECT MIN(date) AS date_____, WEEK(date,6) AS week, SEC_TO_TIME(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))) AS time FROM timesheet WHERE user_id = 50 GROUP BY YEARWEEK(date,6);' | mysql"
-alias dailyhours="echo 'SELECT date AS date_____, WEEK(date,6) AS week, DAY(date) AS day, RPAD(DAYNAME(date),10,'\"'\"' '\"'\"') AS dayn_____, SEC_TO_TIME(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))) AS time_____, ROUND(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))/60/60,2) AS time2____ FROM timesheet WHERE user_id = 50 AND MONTH(date) = MONTH(NOW()) AND YEAR(date) = YEAR(NOW()) GROUP BY date;' | mysql"
 
 # vim: nosmarttab noexpandtab ts=4