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
-----
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
