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
On 2014-09-18 5:25 PM, Jopoy Solano 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
Is this what you mean?
date_format( tsvalue, '%Y-%m-%d %H' )
PB
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
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