Sponsored Content
Top Forums UNIX for Beginners Questions & Answers MYSQL Query for last twelve months of records Post 303005090 by Scott on Thursday 12th of October 2017 02:46:31 PM
Old 10-12-2017
You want to get only the last 12-months' records?

Shouldn't:
Code:
from_unixtime(call_start_time) < DATE_ADD(Now(),INTERVAL- 12 MONTH) )

Be:
Code:
from_unixtime(call_start_time) > DATE_ADD(Now(),INTERVAL- 12 MONTH) )

Is the first part even necessary?
Code:
from_unixtime(call_start_time) < Now()

I would expect everything in the table is older than "now".
 

8 More Discussions You Might Find Interesting

1. Programming

How to query one to many mysql

Hi there, I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks! YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies

2. Shell Programming and Scripting

mysql help : query with 2 conditionals

Hi there, I have a table that stores multiple records for many different servers, each of which is timestamped ... I wanted to write a query that would enable me to only output the "latest" record (based on timestamp) for each "unique" server. So for example my main table looks like this ... (3 Replies)
Discussion started by: hcclnoodles
3 Replies

3. Web Development

mysql query help

hello all i have 2 columns every column in the following format column1 2011-04-01 11:39:54 column2 2019-02-03 00:00:00 i want get difference between above data as following 2 days 11:39 how to do so ? i tried many functions but nothing works please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies

4. Web Development

Updating Records in Mysql Database

so when i issue a command like the below: # mysql --pager=/usr/bin/less -u cactiman -p -e 'select * from data_input' cacti Enter password: ... (2 Replies)
Discussion started by: SkySmart
2 Replies

5. Shell Programming and Scripting

mysql query in shellscript

Hi, I want to access mysql query from database , for that i have tried the below code #! /bin/bash TABLE_NAME=database1 USER_NAME=root IP_ADDR=111.20.9.256 somevar=`echo "select altid from alert where altid='2724'"| mysql -h $IP_ADDR -u $USER_NAME $TABLE_NAME ` echo $somevar ... (1 Reply)
Discussion started by: aish11
1 Replies

6. Programming

mysql query help

Hello i have created mysql query to compare to values and get difference in percentage as following: SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies

7. Programming

mysql query multiple records for one field

Hello Group, What I have is a database with about a dozen fields and one being "City". What I would like to do is to have a custom query on a single field for multiple items (cities) but I don't know how to do this. I know this is probably kids play for most of you but I am lost. What I have... (4 Replies)
Discussion started by: vestport
4 Replies

8. Programming

Need help in mysql query

Hi All, i have a table in mysql with the following data Table name Test Assettype Serial_No Status location Mouse 123456 In Stock chennai Mouse 98765 Allocated chennai Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
IDATE(1)							   User Commands							  IDATE(1)

NAME
idate - A Gregorian/Meladi to/from Hijri/Islamic date converter SYNOPSIS
idate [--gregorian yyyymmdd] [--hijri yyyymmdd] [--simple] [--umm_alqura] [--help] DESCRIPTION
The idate program is a Gregorian to Hijri (and vice-versa) date converter. The application uses and offers multiple calculation methods with not all of them agreeing at all times. The reason for this multiplicity is due to not having one agreed upon method and so various entities develop and advocate their calculations. idate is able to comprehend and calculate both pre-epoch or pre-Hijrah, denoted as "B.H", as well as post-epoch or post-Hijrah, denoted as "A.H", dates. idate also utilizes Gregorian's pre-epoch "B.C" and post-epoch "A.D" dates and notes them per its output. When entering pre-epoch years, negative numbers ought to be utilized. idate when run without any command-line options uses the host machine's current Gregorian date and converts it to Hijri. OPTIONS
idate follows the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of all options is noted below: -h, --help Show summary of options -g, --gregorian yyyymmdd Specify the Gregorian date to be converted where 'y' stands for year, 'm' for month and 'd' for day -hi, --hijri yyyymmdd Specify the Hijri date to be converted where 'y' stands for year, 'm' for month and 'd' for day -s, --simple Specify a simplified output mode -u, --umm_alqura Specify to use the Umm Al-Qura calculation method (used mostly in Saudi Arabia) BACKGROUND
The Hijri calendar is used in most of the Arab world and is the symbolic calendar of the Islamic faithed worldwide. This calendar is known as the "Hijri" (based on the word "Hijrah" - denoting migration in Arabic) to signal Prophet Mohammed's (PBUH) migration from Makkah to Medinah on Thursday, July 15, 622 AD (Julian) or July 19, 622 AD (Gregorian). The Islamic Hijri calendar is strictly lunar (ie. moon-based) with twelve lunar months which do not correspond or track their solar coun- terparts (the Gregorian calendar is a solar or sun-based calendar). Lunar years and thus Hijri years are, on average, about 354 days long resulting in a Hijri year being roughly about 11 days shorter than its Gregorian counterpart. There is much discussion and confusion regarding how best to track the Hijri calendar. A great deal of that confusion is based on the fact that many rely on a human moon sighting to denote the start (or end) of a month (each month of the Hijri calendar starts when a new moon's crescent is observed or is made visible at sunset) as opposed to using an empirical mathematic certainty. The methods presented in this application and its underlying ITL library are strictly arithmetic in nature and do NOT take moon-phases into consideration (in short, observational approximation is not used). LIMITATIONS
The Umm Al-Qura option doesn't function with pre-epoch settings. REPORTING BUGS
Report bugs on the web using http://bugs.arabeyes.org AUTHOR
Written by Nadim Shaikli as part of the Arabeyes.org project. COPYRIGHT
idate is subject to the GNU General Public License (GPL). Copyright (C) 2005, Arabeyes, Nadim Shaikli. SEE ALSO
The ITL library (libitl) from the Islamic Tools and Libraries project. It is the underlying requirement for idate to function. The ITL library was created and is hosted at www.arabeyes.org. idate January 05, 2005 IDATE(1)
All times are GMT -4. The time now is 02:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy