virtualmayur/new_gist_file_0

Created December 9, 2013 10:02

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/virtualmayur/7869953.js"></script>
Save virtualmayur/7869953 to your computer and use it in GitHub Desktop.

Download ZIP

From http://192.168.0.206/phpmyadmin/tbl_sql.php?db=c5_rig_bkp&table=purchase_orders&sql_query=SELECT+%2A+FROM+%60purchase_orders%60&show_query=1&token=093ac6bcb95bb0f4186aa67662e0da0f#querybox

Raw

new_gist_file_0

		(select po.date, po.id, sum(inv.amount) as Amount, DATE_FORMAT( FROM_UNIXTIME(po.date) , '%e %b %Y' ) AS 'date_formatted'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment