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
