Hello,
Try these in build functions from MySQL
mysql> select year('2014-09-17 12:22:16'), month('2014-09-17 12:22:16'),
day('2014-09-17 12:22:16'), hour('2014-09-17 12:22:16');
+
Prashant Ramhit
Administrator - Performance Mgt Systems
Emtel Ltd.
Mobile: +230 5 499 4911
Sent from my Emtel Smart Device
This email and all contents are subject to the following
Disclaimer:"<http://www.emtel.com/email-disclaimer.php>"-----------------------------+------------------------------+----------------------------+-----------------------------+
| year('2014-09-17 12:22:16') | month('2014-09-17 12:22:16') | day('2014-09-17
12:22:16') | hour('2014-09-17 12:22:16') |
+-----------------------------+------------------------------+----------------------------+-----------------------------+
| 2014 | 9 |
17 | 12 |
+-----------------------------+------------------------------+----------------------------+-----------------------------+
Use it with nested queries for a range of dates.
________________________________________
From: Mihail Manolov [mihail.mano...@liquidityservices.com]
Sent: 19 September 2014 03:20
To: <m...@jopoy.com>
Cc: mysql@lists.mysql.com
Subject: Re: extract year-month-day-hour
Try this:
LEFT('2014-09-17 12:22:16', 13)
Mihail Manolov
Senior Manager, Database
Liquidity Services, Inc.
1920 L Street NW
Washington DC 20036
202-467-6868 x3227 (Office)
202-256-9044 (Mobile)
mihail.mano...@liquidityservices.com
LiquidityServicesInc.com
> On Sep 18, 2014, at 18:31, Jopoy Solano <m...@jopoy.com> wrote:
>
> Hi!
>
> I want to say sorry in advance for my ignorance. I was wondering how can I
> extract year-month-day-hour in one go. For example:
>
> From "2014-09-17 12:22:16" to "2014-09-17 12"
>
> The reason for this is I'm trying to generate how much data users
> historically consume every hour for each day.
>
> Thank you.
>
> Jopoy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
